sql select question

[Starbuck]

Hi

The sql command below does not seem to work in SQL Server, can someone show
where I am going wrong

Select * from users where ref like '*JOH*' order by ref

Thanks in advance

 

[Guest]

Starbuck,

The wildcard character should be %, not *.

Kerry Moorman

 

[Jim Underwood]

replace the * with % and you should be all set. I think the * is only for
microsoft access.

 

[Starbuck]

Thanks Guys

replace the * with % and you should be all set. I think the * is only for
microsoft access.