using Cint to convert text field to numeric in WHERE clause
Posted on 2001-09-01
I have a postcode/ZIP field in a table, which is set to text. I need to perform queries that compare this field against a number. I cant change the database schema to set the field value to number, because it requires too many forms to be updated.
Are there any conversion functions, compatible with MS Access/SQL server ?
Ive tried using :-
SELECT tbl_Delegates.ClientID, CLng(Value1) AS Postcode
But this does not seem to work.