Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnc82
Starting Member
3 Posts |
 Posted - 2002-08-18 : 06:37:34
|
| hiSELECT CAST(Postcode AS CHAR(5))FROM PERSON;Postcode by default is a numeric data type, but i wanted to change it to char or text data type.....However it stated a syntax error (misssing operator)anyone can help or fix it?Thanks alot...:-) |
|
|
LarsG
Constraint Violating Yak Guru
284 Posts |
Posted - 2002-08-18 : 08:38:29
|
| The cast operator is not supported in Access (Jet SQL). (There is a specific forum for Access questions.)Use the cstr function to convert instead. |
 |
|
|
johnc82
Starting Member
3 Posts |
Posted - 2002-08-18 : 14:24:49
|
| Well do you go any reference or information beside the 3 tutorial provide from the msdn.... i need a syntax Jet SQL reference which list out all the words, functions, operators and etc etc.... that help me to understand more...Thanks alot.....:-) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-18 : 14:58:39
|
| The Access Help file is the best place for that information. It's already installed on you computer. |
|
|
|
|
|
|
Acess SQL Problem