SQL LIKE

[mousematt]

Hope someone can help.

I have a table that contains user info, One field contains FullName, ie Joe Bloggs. I'm trying to bring back that user from
SELECT * FROM Users WHERE FullName LIKE 'joe'

and nothing comes back, am I doing something wrong?

 

[bperry]

Easy (I think)!
Use the % wildcard.

SELECT * FROM Users WHERE FullName LIKE 'joe%'

 

[mousematt]

that was bloody quick and very easy, thanx it works now.

 

[SusieGirl]

Try to run the select statement like this

SELECT * FROM Users WHERE FullName LIKE 'Joe%'
or
SELECT * FROM Users WHERE Upper(FullName) LIKE 'JOE%'

should hopefylly give you the results you've been looking for.

 

[bperry]

I like SG's suggestion, which definitely might be needed on a case-sensitive Server. (I think the default configuration is INsensitive??)