Blank Values in SQL
Hi all!
Can anyone give me any tips and tricks on how to use the "Replace" Function in SQL to replace Blank cells? I've tried all the tricks I can find and am still unable to replace Blank values!
Here is what I am working with so far:
SELECTÂ
*
,Replace(Replace(Replace(Replace("Post type", 'video_inline', 'Video'), 'photo', 'Graphic'), ' ','Status'), 'album', 'Graphic') as "Type"
FROM report;
-
When I tried this recently, a pop-up indicated the 'replace' function was not allowed. I have had a couple PostgreSQL functions blocked with that type of "not allowed" message. It seems Grow.com might be protecting their environment by blocking certain functions.
I found work-arounds for my needs. Did you by chance ask Support and get a response?
Please sign in to leave a comment.
Comments
1 comment