Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hotshot_21
Yak Posting Veteran
97 Posts |
 Posted - 2006-02-16 : 01:35:01
|
| i have three fields in my .aspx page.and when user enters information into it.i want to use LIKE statement to return all the three columns which are in my table. iam using this statemnt but i get errorselect jobtitle,location from jobpost where jobtitle,location like '%programmer%','%City%'please help me out in returning all the matching fields from a particualr row in a table. |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-16 : 01:39:56
|
| Use This..select jobtitle,location from jobpost where jobtitle like '%programmer%' and location like '%City%'Are you sure about using a Like Statement? Cant you replace it with "=" |
 |
|
|
hotshot_21
Yak Posting Veteran
97 Posts |
Posted - 2006-02-16 : 01:49:27
|
| i have to search my table for the similar pattern and then display it to user thats y not using "=". |
|
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-16 : 01:52:11
|
quote:
Originally posted by shallu1_gupta
Use This..select jobtitle,location from jobpost where jobtitle like '%programmer%' and location like '%City%'
Then Go with this.. |
|
|
|
|
|
|
using LIKE clause