finding ASCII characters

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

Shouldn't this find everything with a space in it? '*' & Chr(32) & '*'
Shouldn't this find everything with 2 spaces in it? '*' & Chr(32) &
Chr(32) & '*'

It's not working? What m I doing wrong here?
thanks!
 
Interesting...

Is this for Access or SQL Server?
If Access, the "*" is correct.
If SQL Server, you need to use "%"

Have you tried: Select... From... Where <field> Like "* "


--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top