View Single Post
  #1 (permalink)  
Old July 3rd, 2003, 10:58 AM
owain owain is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Cardiff, , United Kingdom.
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default CAST or CONVERT in Access

The CAST and CONVERT column functions do not seem to work in MS Access. How can I convert a text column to an integer column?

For example, I have read that in SQL2 you can use the function CAST(Col1 AS int) and in T-SQL you can use CONVERT(Col1, int) to convert Col1 to an integer.

Neither of these seem to work in Access, am I doing something wrong, is it not possible, or is there another function I can use?

Regards
Owain Williams
__________________
Regards
Owain Williams