Re: SUBSTR() Function

[Justin Keller]

Ok, yeah I figure it out, I was starting at index 0, starts at 1.

Is there a way in the query to check if the returned value of:

SUBSTRING(message, 1, 50)

Is indeed completely full, i.e. 50 characters, and if so, strip off the last 3 and replace with ...

Example:

'This is a test string that is returned from blah';

Becomes:

'This is a test string that is returned from b...';