Upper

[#1]

Hi All,

The following is the SQL Server 2005 query:

select

UPPER (AddressLine1)

from

Person. Address

But How can i convert this query into Qlikview?

Best Regards,

Khalid

[sparur]

Hello, KHalid.

LOAD

Upper(AddressLine1) as AddressLine

;

sql select
AddressLine1
from
Person.Address

[#3]

SQL Error:[Microsoft][SQL Native Client]Dialog failed
SQL State:IM008
select UPPER (AddressLine1)
from Person.Address

[#4]

Try like this:

Upper(AddressLine1) as AddressLine

[johnw]

Khalid11 wrote:
SQL Error:[Microsoft][SQL Native Client]Dialog failed
SQL State:IM008
select UPPER (AddressLine1)
from Person.Address<div></div>

Please have another look at how Anatoly wrote the expression. See how the upper(AddressLine1) as AddressLine is done in the LOAD statement, not in the SQL statement? You appear to still be doing it in the SQL statement. If so, that is why you are getting an error. You need to do it in the LOAD statement instead.