How do I change data in my QV Load

Thu, 11 Apr 2013 08:46:57 GMT

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

Re: How do I change data in my QV Load

Thu, 11 Apr 2013 16:21:42 GMT

I just had to do it in SQL

with a

SELECT

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