Fordraiders
asked on
need to change a value to <blank> if the word is "NO"
need to change a value to <blank> if the word is "NO"
I have this field, which has the "YES" or "NO" values.
If the value = "Yes" bring back a "Yes"
if the value = "NO" bring back nothing
[PayTermsTiedVolCommi] as 'Payment Terms tied to VC Performance'
Thanks
fordraiders
I have this field, which has the "YES" or "NO" values.
If the value = "Yes" bring back a "Yes"
if the value = "NO" bring back nothing
[PayTermsTiedVolCommi] as 'Payment Terms tied to VC Performance'
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can surely use a case statement:
select *, case when YourField = 'No' then '' else YourField end as NewYourField
If you want to avoid a CASE and/or if the column could also be NULL, this would handle both NULL and NO being set to '':
ISNULL(NULLIF([PayTermsTie dVolCommi] , 'NO'), '') as 'Payment Terms tied to VC Performance'
ISNULL(NULLIF([PayTermsTie
ASKER
thanks all...
SELECT
CASE [PayTermsTiedVolCommi]
WHEN 'NO' THEN ''
ELSE [PayTermsTiedVolCommi]
END as 'Payment Terms tied to VC Performance'
FROM table ....
... or ...
SELECT IIF([PayTermsTiedVolCommi]