select empty string - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

select empty string

Author

Topic

luciffer
Starting Member

8 Posts

Posted - 2004-07-11 : 19:37:12

Can you select an empty string in the same manner as you can select 0 for every row?

ex:
select id, 0 as amount_paid
from table_a

I can't get it to work with an empty string as
select id, 0 as amount_paid, ' ' as customer_name
from table_a

kselvia
Aged Yak Warrior

526 Posts

Posted - 2004-07-11 : 19:43:58

Yes you can do that. I see no reason why your query would not work. What error are you getting?

luciffer
Starting Member

8 Posts

Posted - 2004-07-11 : 19:48:00

lol, ooopps I got the PEBCAK error...Problem Exists Between Chair And Keyboard.

Sorry...Delete this thread if mod comes by.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources