AnsweredAssumed Answered

SUBSTRING SQL Expression

Question asked by tcalico on Jun 11, 2014
Latest reply on Jun 11, 2014 by iamurray
Not having much experience in SQL or Python, I'm trying to take a shot at labeling a field using a SUBSTRING expression to return only the first 6 characters of a field.

The field is [SITE_ADDRE]

My expression looks like this:
SUBSTRING ([SITE_ADDRE] FROM 1 FOR 6)

I'm getting an error message so I know this is incorrect.

Any suggestions would be much appreciated.

Outcomes