Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

asked on

A SQL script to search constant with a table in Ms SQL

We need to search various constant value of a column within a table.

The constants are 'okn123', 'OKI987987', 'pop9090' in the Itemcode column of the table.

We want to know if exist in the table
ASKER CERTIFIED SOLUTION
Avatar of tlovie
tlovie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Great, thanx all!
Avatar of jana

ASKER

Somehow I can reward the points, its saying that I am closing.

please advice
Avatar of jana

ASKER

Thats exactly what we are doing, but will try again.
Avatar of jana

ASKER

I dont see that it was rewarded, its asking for a comment to close