Change Lower Case to Upper Case

[yogi77]

Hi,

Is there an equivalent of the VB function 'Ucase' in TSQL? I want to perform an update to certain fields, making all entries upper case. At the moment there is a mixture of lower and upper case.

Thanks in advance. "Let us not condemn ignorance, let us condemn the reluctance to share"

 

[yogi77]

It's OK thanks, I found it;

upper() for changing to upper case and lower() for changing to lower case.

pretty intuitive I suppose... "Let us not condemn ignorance, let us condemn the reluctance to share"