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 |
|
papershop
Starting Member
27 Posts |
 Posted - 2011-09-06 : 22:59:06
|
| dear friendi have 2 data ex: sacrosa (imported) and sacrosa (exported)i want to search data sales of that sacrosai use this this sintaxselect * from product sales where name = 'sacrosa (imported)'..and the result is emptyif i use select * from product sales where name like '%sacrosa (imported)%'..the result is emptyso what should i do?@papershop |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-06 : 23:05:53
|
| that clearly suggests name value stored in table is not sacrosa (imported)check thisselect name from [product sales]and see what it returns------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-09-06 : 23:10:42
|
| also, does the ".." indicate that you have other criteria? Copy and paste the entire, actual statement you are trying to run.Be One with the OptimizerTG |
|
|
|
|
|
|
searching data