"Starbuck" <Starbuck@tisconi.com> wrote in message
news:YTq9f.19798$Ce5.17144@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
>
>

"goodman" <goodman93@hotmail.com> wrote in message
news:uCKbDdj3FHA.252@TK2MSFTNGP15.phx.gbl...
> Use the '%' symbol instead of the '*'
>
> Brian
>
> "Starbuck" <Starbuck@tisconi.com> wrote in message
> news:YTq9f.19798$Ce5.17144@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
>>
>>
>
>