Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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 (2)
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 <> ' ';

 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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