Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jacob
Contributor III
Contributor III

'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
swapniltaz
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
PradeepReddy
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
Anil_Babu_Samineni

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 <> ' ';

 

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
swapniltaz
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 

 

 

 

)

Jacob
Contributor III
Contributor III
Author

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