How to replace blank with Null across the select Statement in sql query

Question

I have a sql query which has 290 columns in SELECT statement. I need to apply a condition when any of the columns values is '' or only , then replace it with NULL across the columns... any help?

I can use case statement but writing 290 times does not serve the purpose... so any other alternative..

290 columns in select ??? and you have tagged it with `Performance` .. — Deepshikha, Feb 13 '15 at 07:37
i can use coalesce function or isnull but i dont want to apply for each n every column individually... any universal function available... — Robin, Feb 13 '15 at 07:40
possible duplicate of [convert empty space to null](http://stackoverflow.com/questions/3701812/convert-empty-space-to-null) — Vojtěch Dohnal, Feb 13 '15 at 08:09

score 0 · Answer 1 · edited Apr 23 '15 at 11:04

0

Better handle all your logic in your programming language. You can use this:

select  DECODE(<column name>, '', '1', '0') from <tablename>

edited Apr 23 '15 at 11:04

Pang

9,073
146
84
117

answered Feb 13 '15 at 07:43

JAYT

11

How to replace blank with Null across the select Statement in sql query

1 Answers1