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

--

Kevin Martin
Motor Trade Technologies

[Kerry Moorman]

Starbuck,

The wildcard character should be %, not *.

Kerry Moorman
"Starbuck" wrote:

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

--

Kevin Martin
Motor Trade Technologies

[Jim Underwood]

replace the * with % and you should be all set. I think the * is only for
microsoft access.
"Starbuck" <St******@tisconi.com> wrote in message
news:DU******************@newsfe1-gui.ntli.net...

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

--

Kevin Martin
Motor Trade Technologies

[Starbuck]

Thanks Guys

"Jim Underwood" <ja*************@fallonclinic.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

replace the * with % and you should be all set. I think the * is only for
microsoft access.
"Starbuck" <St******@tisconi.com> wrote in message
news:DU******************@newsfe1-gui.ntli.net...

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

--

Kevin Martin
Motor Trade Technologies