Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I just had to do it in SQL
with a
SELECT
CASE WHEN CHARINDEX('+',Dominant_Car) > 0 THEN 'SOMETHING' ELSE 'SOMETHING' END AS TEST
I just had to do it in SQL
with a
SELECT
CASE WHEN CHARINDEX('+',Dominant_Car) > 0 THEN 'SOMETHING' ELSE 'SOMETHING' END AS TEST