Regarding Query Generator One Column Extra

[Former Member]

hi.

i have one requirement

ie.

normally

sleect ordr.cardcode from ordr

i put this query in query generator 

so, the result will come like

s

y

x

p

but what i need is, i want  one column extra each time the value of this column is  'co'

like

co s

co y

co x

co p

is it possible...

i need your valuable suggestions..

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this:

SELECT 'CO' + T0.[CardCode] FROM ORDR T0

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

hi,

I will check it..

[Former Member]

Hi Srinivas,

Yes, Possible. Please try below.

SELECT 'CO' as 'CO',  T0.[CardCode] FROM ORDR T0

Hope this help

--

--

Regards::::

Atul Chakraborty

[Former Member]

Dear Srinivas,

if you Need the column Extra

try this also

SELECT 'CO' , T0.[CardCode] FROM ORDR T0

Regards

Ajith

[Former Member]

Hi.Ajith,

How r u..?

thanks for your reply.

R .Srinivas(Former Employee of Tespainfotech pvt ltd..)

[Former Member]

Hi Srinivas,

Fine Srini..hope you are fine..

If you got the answer please close this thread with tag correct answer...

Regards

Ajith