Blank Values in SQL

Follow

Jacob Tucker

• July 27, 2022 16:41

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;

0

• 

  Brian Richardson

  • September 12, 2022 20:11

  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?

  0

  Comment actions Permalink

Please sign in to leave a comment.