Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

'SUBSTR' is not a recognized built-in function name- Script Error

Hi All, 

I am getting following .

Connector reply error: SQL##f - SqlState: 37000, ErrorCode: 195, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]'SUBSTR' is not a recognized built-in function name.: SQL SELECT DATAAREAID,SUBSTR(STORE_NUMBER,4) as STORE_NUMBER1,STORE_NUMBER,SUPERVISOR,AREA,CATEGORY,SHOPNAME FROM shop_list where REGION = 'UAE' AND COMPANY = 'RETAIL' and STORE_NUMBER <> ' '

My Script

SQL SELECT DATAAREAID,SUBSTR(STORE_NUMBER,4) as STORE_NUMBER1,STORE_NUMBER,SUPERVISOR,AREA,CATEGORY,SHOPNAME FROM shop_list where REGION = 'ACX' AND COMPANY = 'RETAIL' 
and STORE_NUMBER <> ' ';
Labels (3)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Hi ,

 

I undesrtand you are using SQL server , In SQL server we have Substring function as Substring(STORE_NUMBER,4)

And not Substr(STORE_NUMBER,4) , Chnage this and it should work 

 

 

 

)

View solution in original post

4 Replies
Highlighted
Specialist II
Specialist II

if you are extracting the data from SQL server try like this..
substring(STORE_NUMBER, Start_Position_Number, Length) as SortNumber1
Highlighted

I didn't see any field related from SELECT statement like red color? Did you taken any where?

SQL SELECT DATAAREAID,SUBSTR(STORE_NUMBER,4) as STORE_NUMBER1,
STORE_NUMBER,SUPERVISOR,AREA,CATEGORY,SHOPNAME FROM shop_list
where REGION = 'ACX' AND COMPANY = 'RETAIL' and STORE_NUMBER <> ' ';

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III
Contributor III

Hi ,

 

I undesrtand you are using SQL server , In SQL server we have Substring function as Substring(STORE_NUMBER,4)

And not Substr(STORE_NUMBER,4) , Chnage this and it should work 

 

 

 

)

View solution in original post

Highlighted
Contributor II
Contributor II

Thanks for help

i have one more question

can u help me with this.

https://community.qlik.com/t5/New-to-Qlik-Community/SQL-IsNull/m-p/1524405#M7802