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

Do you know data definition language, data control language and data manipulation language?

987


How to use the inserted and deleted pseudo tables?

916


What happens if time-only values are provided as date and time literals?

954


What are scheduled tasks in sql server?

1011


What are clustered and non-clustered index?

950


What is difference between view and materialized view?

891


What is the difference between rank and dense_rank?

991


What are the ways available in sql server to execute sql statements?

1041


Does group by sort data?

848


Explain the cursor lock types?

983


What is the distinction amongst delete and truncate?

1003


When to use Inner join & when to use subquery?

1083


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2029


Tell me what is normalization? Explain different forms of normalization?

983


What stored by the master?

904