How do I change data in my QV Load

[#1]

I have somethign which looks like the below

cen_CarOwnership:

CrossTable(cen_CarOwnership, cen_CarOwnership_Data, 2)

SQL SELECT

    [2001OA_CODE] AS link_Census_Code,

    Dominant_Car AS cen_Dominant_Car,

          Car_None,

          Car_1,

          Car_2,

          Car_3plus

FROM

    DCM.cen.CarOwnershipOA;

How would I do the following

If Dominant_Car contains a + character, then replace the whole string with the text NA

Many thanks

[#2 · Accepted solution]

I just had to do it in SQL

with a

SELECT

CASE WHEN CHARINDEX('+',Dominant_Car) > 0 THEN 'SOMETHING' ELSE 'SOMETHING' END AS TEST