SQL Query to check numbers

[mathon]

Hi,

I have a table called TableA, this table has columsn Column1, Column2, Column3 and Column4. Column3 contains 8-digit numbers saved as text.
Now I want to check if a certain amount of numbers is already in the table. I guess I have to use the keyword IN and the numbers I want to check connected to a string.

Does anybody know how the SQL Query has to look like and how the string of the numbers has to look like?

regards
matti

 

[PHV]

What have you tried so far and where in your SQL code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mathon]

I actually dont really know how to define this sql statement, could you help me with that? :-/