Use IN and LIKE both togather

• KcV

  SSCommitted

  Points: 1714

  More actions

  November 16, 2010 at 2:55 am

  #141437

  Hi all,

  can anybody say that

  how can i use IN and LIKE both togather in same query and same field ?

  select * from pe where yno in like (

  '%85452-1',

  '%29212-2',

  '%61954-1',

  '%34483-2')

  above query gives me following error :

  Incorrect syntax near the keyword 'like'.

  thanks

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  November 16, 2010 at 3:10 am

  #1251188

  KcV (11/16/2010)

  ---

  Hi all,

  can anybody say that

  how can i use IN and LIKE both togather in same query and same field ?

  select * from pe where yno in like (

  '%85452-1',

  '%29212-2',

  '%61954-1',

  '%34483-2')

  above query gives me following error :

  Incorrect syntax near the keyword 'like'.

  thanks

  Ok, this is purely what you asked for and not my recommendation:

  select [columnnames] from pe where yno in (select [columnname] from pe

  where yno like

  '%85452-1'

  or yno like '%29212-2'

  or yno like '%61954-1'

  or yno like '%34483-2')

  Since the column names in your "IN" and "LIKE" statement are the same, try the following:

  select [columnames] from pe where yno like

  '%85452-1'

  or yno like '%29212-2'

  or yno like '%61954-1'

  or yno like '%34483-2'

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle