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
848 Views

(page loaded in 0.035 seconds)

6/6/2014 2:23:44 PM


Reply: