English Query

• ksharma423

  SSC Veteran

  Points: 248

  More actions

  April 17, 2003 at 8:16 am

  #357748

  Hi,

  I have a resource catalog database. I want to display all Servers running Microsoft OS (irrespective of NT/2000). To do this I need to use 'Like' operator in the query, can anybody suggest how I can make English Query use 'like' and not '='.

  Thanks,

  ~Karthik

• April 21, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• sherpedro

  SSC Rookie

  Points: 28

  More actions

  April 21, 2003 at 4:05 pm

  #454844

  Hi, i really don't get it...

  I suppose you know how the 'LIKE' operator work! i.e.

  SELECT * FROM Table WHERE Field LIKE 'PRE%'

  will retrieve any row where 'Field' begin with 'PRE'.

  Is that what you were looking for? If not just let me know a little more.

  Ciao!