Logo 
Search:

Asp.net Answers

 Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds
  Question Asked By: Sienna Hughes   on Sep 26 In Asp.net Category.

How to Concatinate String for DataTextField of DropDowns


  
Question Answered By: Dustin Dean   on Sep 26

Once other thing you are probably best doing as well is using the IsNull
operator, any nulls in either column will make the whole statement return a
null (A NULL + a string  always = NULL)...

select IsNull(FName, '') + ' ' + IsNull(LName, '') as fullname

That is assuming you are using MS SQL?

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to Concatinate String for DataTextField of DropDowns Or get search suggestion and latest updates.


Tagged: