how to convert lowercase to uppercase in sql

occurs.Open the Register. bat file in notepad and see the following code. It is obviously used to Register dll (regasm is an assembly registration tool) % SYSTEMROOT % \ Microsoft.net \ Framework \ v2.0.50727 \ regasm "% ProgramFiles % \ Red Gate \ SQL Prompt 5 \ RedGate. SQLPrompt. SSMSUI. dll" Since automatic registration fails, register it manually. Execute the following two commands in the command line respectively (you can also register with. NE

SyntaxUse CAST: CAST (expression AS data_type) Use CONVERT: CONVERT (data_type [(length)], expression [, style]) ParametersExpression Is any valid Microsoft SQL Server "expression. For more information, see expressions. Data_type The data types provided by the target system, including bigint and SQL _variant. User-Defi

GrammarUse CAST: CAST (expression as data_type) Use CONVERT: CONVERT (data_type[(length)], expression [, style]) ParametersExpression Is any valid Microsoft SQL Server expression. For more information, see expressions. Data_type The data types provided by the target system, including bigint and sql_variant. You cannot use user-defined data types. For more

Label:1, the number of characters to convert to Chinese capital, Attention 100==> 100 rather than ==> 100 123==> 123 rather than ==> 123 CREATE FUNCTIONFn_numberconvertchinase (@number NVARCHAR( -)) RETURNS NVARCHAR( -) as BEGIN DECLARE @res NVARCHAR( -) DECLARE @char CHAR(1) SET @res = "' SET @char = substring(@number,1,1) SELECT @res =( Case @char when '1' Then 'a' when '2' Then 'two' when '3' Then 'three' when '4' Then 'Fou