Convert to caps ?

Hai,

This is my table ?

Table1

hyundai

Laptop

Samsung

onida-tv

How to convert all these values to caps .

Table1

HYUNDAI

LAPTOP

SAMSUNG

ONIDA-TV

UPDATE Table SET column = UPPER(column);

convert sql selects into xml format

hai all,

I need some help and is very urget. I wan to convert the output of the sql query into xml format but i don hv any idea on how to do it. I'm using vb.net for this application.

Hope your guys out there can help me on this.

Regards,

KYY

Read up on the FOR XML clause that SQL Server supports: http://msdn2.microsoft.com/en-us/library/ms191268.aspx