Looking for space in DataBase string

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


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories