SQL Gives Data Type Mismatch in Criteria Expression

[Formby]

I've had this problem many, many times. And it's always turned out to be a small typo or "" around an integer, but I just cannot find what's wrong with my SQL Statement this time!

SELECT Card_ID FROM Payment WHERE Customer_ID = 12 AND Card_Number = 1231231231231231

The table and fields are named correctly (the table is actually a query).

The only thing I can think of is the card number being too large, however it works fine in my INSERT INTO statement!
All of the fields are formatted as their respective data types, ie. Integers are set to integer, not string.

Any help is much appreciated!

[__avd]

Change column type to BigInt.

[debasisdas]

You mean to say this number 1231231231231231 is being stored in an integer field in the database ?

[Formby]

You mean to say this number 1231231231231231 is being stored in an integer field in the database ?

Ahh, I think I've just figured it out. It's stored as a String, therefore it needs quotes around my value! Thanks for the help!