Database Query Assistance

[endurox]

AhText Database Records:

AhTextNum | OtherFields
662 | OtherFields
662a | OtherFields
662b | OtherFields
662c | OtherFields

Heres the sql: (THIS ONE WORKS FINE)
SELECT * FROM AhText WHERE AhTextNum = 662

Heres the broken sql:
SELECT * FROM AhText WHERE AhTextNum = 662a

How would I write a working sql statement to retrieve the record row 662a?

Thanx
Endurox

[bubblenut]

You need to delimit the value with quotes as it's a string rather than an integer.

SELECT * FROM AhText WHERE AhTextNum='662a'

This will still work for the integer, like so.

SELECT * FROM AhText WHERE AhTextNum='662'

Hope this helps.
Rob