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.