UPPER() IN SCRIPT

[#1]

SELECT

DISTINCT [Company No_] , UPPER([Company Name])

FROM

[ABC]

Above query in MS SQL 2005 its working properly but when I copy to Edit script its show error <Company Name> not found.

please tell me why or i use another function in the place of upper.

[sparur]

Hello,

try that:

LOAD

[Company No_] ,

UPPER([Company Name]) as [Company Name]

;

SELECT
DISTINCT [Company No_] , [Company Name]
FROM
[ABC]

[#3]

Thanks for you reply, but why not supported in select.

[sparur]

may be your ODBC driver doesn't support this function.

[#5]

Thanks once again and you are right, can you guide me how can i resolve this problem.

[sparur]

Why are you no want to use my approach ?

[#7]

My dear Friend, i am already used your approach, but i want to know how i update my ODBC or else.

[sparur]

I think you shouldn't worry about this 🙂 Why? your problem was solved.