Advanced Minds

  • Decrease font size
  • Default font size
  • Increase font size
  • default color
  • red color
  • green color
FireBoard
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Programing ASP Programing
sql replace null value Need help with SQL Replace (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: sql replace null value Need help with SQL Replace
#4571
Joey Martin (Visitor)
Click here to see the profile of this user
Birthdate:
sql replace null value Need help with SQL Replace  
I have a basic sql select statement: select name,address from testtable How do I do replace a NULL value in address with a blank, or space or something? I have tried: select name, replace(address,null,' ') as address from testtable but this does not work. Thanks! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4572
Ryan Waight (Visitor)
Click here to see the profile of this user
Birthdate:
sql replace null value Need help with SQL Replace  
Have a look at ISNULL in BOL
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4573
Tom Moreau (Visitor)
Click here to see the profile of this user
Birthdate:
sql replace null value Need help with SQL Replace  
Try: select name, isnull(address,' ') as address from testtable
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
nieautoryzowano no auth brak autoryzacji wymiana linkow sprawdz autoryzacje
top news car loan dive hero ground beef recipes ebusiness news