SQL FUNCTION IN SELECT

[#1]

I am trying to use a SQL prebuilt function in my SELECT statement  but it errors out saying " not found". Do you know why this would be happening.

Script I am using is

load *;

SELECT

dbo.fn_adjusted_date( table.column1)

FROM [ARSystem].[dbo].

(NOLOCK)

order by column1;

Am I missing any syntax?

[arsal_90]

Order by Column 1 is the mistake what i think qlikview didn't read column 1 please pass column name instead of column 1

[#3]

I have used the column_name ... not column 1... Sorry to confuse you!

[anbu1984]

Sql keyword is missing.

ODBC CONNECT TO ....

Load *;

Sql SELECT

dbo.fn_adjusted_date( table.column1)

FROM [ARSystem].[dbo].

(NOLOCK)

order by column1;

[maxgro]

you can check the syntax of the sql select with your db tool

if the db is sql server, sql server management studio

then, when you have a checked statement, copy it in qlikview and add load *;

[arsal_90]

Anbu is right SQL keyword is missing

[Anonymous]

load

*

;

SELECT

column_name

FROM [nameDB.[dbo].[name_table]

order by colum_name;

[#8]

I added SQL but did not work either!