how to mearge

[Vinay Patel]

hey all

i have one big problem

i want to select data of 2 column but out put shoul come as one column
how to do this?

any one have idea?

Thanks in Advance

[Vinay Patel]

i mean to say as follow

if i have 2 colume like [fname] and [lname] then out put shoud be
[name] column

means
[fname] [lname]
vinay patel

then

[name]
vinay patel

[Fábio Pinheiro]

try this

select fname+' '+lname as name from yourtable

Vinay Patel escreveu:

[jun]

I Agree Fábio Pinheiro

 

2006/12/19, Fábio Pinheiro <fcpin...@gmail.com>:

[Vinay Patel]

thans a lot Fábio Pinheiro