Hi.
I have this strings in my database table:
"1234567890"
"123 456 789 0"
I want to find only the "456" from the second string (with spaces before and after)
Tried:
select * from myTable Where colName like '% 456 %'
or
select * from myTable Where colName like '%'+space(1)+'456'+space(1)+'%'
or
select * from myTable Where colName like '%'+char(32)+'456'+char(32)+'%'
and nothing.
From the Query Analyzer it's OK but not from my application (VB6).
What could be the resone ?
thanks