I'm trying to display a string id w/out the last 4 chars if the last 3 are = '999'.
Had put the logic in the DataSource query as:
,IF Right(tableName.StringId, 3) = '999'
THEN SUBSTR(tableName.StringId, 1,
LENGTH(tableName.StringId) - 4)
ENDIF AS StringId
which worked great except for orphaning the column name which caused problems with other code.
Any suggestions of how to keep the db column name qualified (tableName.StringId instead of StringId) while displaying the field without the last 4 chars?