Error im geeting while using in statement in Sql

[srinivasa1]

Pls can any one help me out to use in Statement in Sql i have script like bellow ie:

where

thx in adavance

ReviewStatus in ('N','R','RED','YELLOW') ;

[srinivasa1]

hi thx its working without Error.

But No date retrived

Its simlary to SqlServer IN Statement ? or exactely replacing my OR Condtion?

[srinivasa1]

Thx Michale oncce agian.

but how can achive this .i dont want to considred case sensetive value.?how can i use wildcards?same sa wildmatch.i wll check my end too for wildcards

srini

[maneshkhottcpl]

Hi,

U cane use Wildmatch(FieldName,'*ABC')>0

will match the end string with ABC and starting with any.

'ABC*' will start with ABC and end with any.

[Anonymous]

Correct Manesh,
I only can add that the ">0" part is optional, it is implied. There is no difference between
Wildmatch(FieldName,'*ABC')>0
and
Wildmatch(FieldName,'*ABC')

[srinivasa1]

Hi

I think its not working for me is im doing something wrong in script as bellow.

where

ReviewStatus ='N' OR ReviewStatus='R' OR ReviewStatus='RED' OR ReviewStatus='YELLOW' and ConsolidationFlag='NO';

Vs

where Wildmatch(ReviewStatus,'N','R','RED','YELLOW') and ConsolidationFlag='NO';

[Anonymous]

Obviously you'll get diferent results. The first one should be:
(ReviewStatus ='N' OR ReviewStatus='R' OR ReviewStatus='RED' OR ReviewStatus='YELLOW') and ConsolidationFlag='NO'