topic UPPER() IN SCRIPT in QlikView

UPPER() IN SCRIPT

Tue, 08 Jun 2010 11:40:39 GMT

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 — Tue, 08 Jun 2010 11:43:06 GMT

Hello,

try that:

LOAD

[Company No_] ,

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

;

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

Tue, 08 Jun 2010 11:50:27 GMT

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

sparur — Tue, 08 Jun 2010 11:56:07 GMT

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

Tue, 08 Jun 2010 12:03:37 GMT

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

sparur — Tue, 08 Jun 2010 12:06:42 GMT

Why are you no want to use my approach ?

Tue, 08 Jun 2010 12:24:17 GMT

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

sparur — Tue, 08 Jun 2010 12:33:37 GMT

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