trying to select the last 3 digits of a field

  • Follow


hello all

this is the query im using (I am looking to get the last 3 characters
of a field):

rep_code: Right(tablename.fieldname,3)

And I get this error:
IDBC--call failed
[Informix][Infomirx ODBC Driver][Informix]A syntax error has occurred.
(#-201)

Is it something wrong with my query or something outside Access 2003
(since the table I am trying to work with its using an ODBC conexion)?

Any ideas???


Thanks
0
Reply erick 11/20/2007 9:52:06 PM


0 Replies
885 Views

(page loaded in 0.033 seconds)


Reply: