Help with Jet SQL syntax using SUBSTRING 1

[t16turbo]

hi all,

I have a bit of SQL that normally works using an Oracle application:

FROM NIKU.ODF_CA_PROJECT LEFT JOIN Sub_Project ON  (SUBSTR(NIKU.ODF_CA_PROJECT.DSTI_PROJ_REF,1,6) & "-" & SUBSTR(NIKU.ODF_CA_PROJECT.DSTI_PROJ_REF,8,1)) = Sub_Project.displayProjectNo
;

does anyone know how this translates using Access Jet?

 

[lespaul]

you have to use the MID function instead of SUBSTRING.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual