Use a Conditional Expression

To return a value based on a condition, you can use the CASE conditional expression.

For example, the Account Type ID field of ssot__Account__dlm has the values 'Customer - Direct' and 'Customer - Channel'. You don’t want the 'Customer - ' prefix. Use the CASE conditional expression to return a different value for the Account Type Id field based on the original value. The ELSE expression covers the field values that don’t match the conditions and returns the field value unchanged.

1SELECT "ssot__AccountTypeId__c",
2    CASE
3        WHEN "ssot__AccountTypeId__c" = 'Customer - Direct' THEN 'Direct'
4        WHEN "ssot__AccountTypeId__c" = 'Customer - Channel' THEN 'Channel'
5        ELSE "ssot__AccountTypeId__c"
6    END
7FROM "ssot__Account__dlm"

In the condition, you can use all the same operators (=, <, <=, LIKE, BETWEEN, ...) that you can use in WHERE clauses.