Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I have Two table First have UserName and second is address,
in address table more than value relegated to UserName
table, i want to fetch 2nd address if exist other wise 1st
address access

Answer Posted / arun

use Coalesec(addrress1,address2)

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between mongodb vs. Sql server?

1095


How to convert a unicode strings to non-unicode strings?

1102


Explain user defined views?

963


What is the usage of sign function?

1109


How to check if stored procedure is running in sql server?

1059


Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1032


what is difference between view and Dip.

2409


How to Update from select query in sql server?

1060


Can we use custom code in ssrs?

1114


How to count rows with the count(*) function in ms sql server?

1014


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1054


What are the restraints imposed on the table design by a merge replication?

1038


What are the differences between clustered and non-clustered index?

1032


What is use of dbcc commands?

1071


What is the difference between stored procedure and user defined functions?

1190