Where.....command contains unrecognised pharse/keyword

[Anonymous]

Hi

trying to load a table with this where clause but instead i get the above script error

WHERE clicod = 'BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD';

[alexandros17 · Accepted solution]

the syntax is:

where clicod = 'BX' Or clicod = 'BI' OR  ....

if you are writeing a query in sql you can write

where clicod in ('BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD')

Hope it helps

[#3]

Hi,

Try

WHERE clicod IN( 'BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD');

Rebeca

[kumarnatarajan]

hi,

try this

Ex:

where WildMatch(clicod,'BX','BI','BW','BS','BF','BL','BT','BA','BE','BP','BM','BK','BD');

[narender123]

Hi,

Try this,

WHERE clicod = 'BX' or 'clicod='BI' or clicod='BW' or clicod='BS' or clicod='BF' or clicod='BL' or clicod='BT' or clicod='BA' or clicod='BE' or clicod='BP' or clicod='BM' or clicod='BK' or clicod='BD';

Thanks

Narender

[Anonymous]

That was very helpful, Thanks alot guys