SUBSTRING

[jrc1]

I am reading a file into $data then trying to use a substring command like
LET $BANK_NUMBER=SUBSTRING($DATA,26,9)
but receive the following error:

Error on line 125:
<SQR 4008> Unknown function or variable in expression: substring Let $BANK_NUMBER=SUBSTRING<$DATA,26,9>

I am using the SUBSTRING command in the correct context.

 

[tlbroadbent]

This is a Microsoft SQL Server forum. The language snippet you posted is SQR. The problem is that you are trying to use a SQL database server function as an SQR function. Terry
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin