Multiple Like statement

[stu75]

Hi

I'm trying to create a SELECT with multiple LIKE
e.g.

strSQL = "select user from log where workstation like 'fr132' and date =
curdate() and logout = '00:00';"

Trouble is there are about 30 different workstations e.g. fr130, 112, etc. So
I can't imagine the best solutions is to put: Workstation LIKE 'fr132' or LIKE
'fr130' or LIKE 'fr112'

I've really been scratching my head with this one.

Thanks

Stuart

[Alexandru COSTIN]

Hi,

> Trouble is there are about 30 different workstations e.g. fr130, 112, etc. So
> I can't imagine the best solutions is to put: Workstation LIKE 'fr132' or LIKE
> 'fr130' or LIKE 'fr112'

I think you should use the wildcard for SQL queries - %

Workstation LIKE 'fr%' AND

Good luck

Alexandru

>
> I've really been scratching my head with this one.
>
> Thanks
>
> Stuart
>
>

--
InterAKT Online - Dreamweaver extensions
[url]http://www.interaktonline.com/[/url]