I'm trying to trim a field & select only the distinct records - In access the sql is:
select distinct Left([col_id]),4) as Color
from colors
However this gives me a syntax error in informix. I can't find an obvious way to keep only the first 4 digits of the field. Ultimately I'll need to take the last 4 digits in another view so if you can assist me with this I can probably figure out how to pull the last 4 digits.
Thanks
Gina
select distinct Left([col_id]),4) as Color
from colors
However this gives me a syntax error in informix. I can't find an obvious way to keep only the first 4 digits of the field. Ultimately I'll need to take the last 4 digits in another view so if you can assist me with this I can probably figure out how to pull the last 4 digits.
Thanks
Gina