What is the SQL equivalent of this Oracle code? 1

[HiBoo]

I'm trying to convert the following Oracle code to SQL. Could you please help? I've got no documentation on Oracle functions to explain how they work.

substr(BRANCH, -1, 1) || substr(REGISTERNUMBER, -3, 3);

In Oracle, the BRANCH attribute is a VARCHAR(4) and the REGISTERNUMBER is a VARCHAR(6). The SQL attributes are of the same datatype.

I know that the SQL version s/b SUBSTRING(branch,?,?) + SUBSTRING(registernumber,?,?) but I'm not sure of the proper numbers.

Thanks for any input...

 

[tgriffin]

You should be able to use

SUBSTRING(BRANCH, [STARTING POSITION], [ENDING POSITION])

SUBSTRING(REGISTERNUMBER, [STARTING POSITION], [ENDING POSITION]

I guess it depends on what you are extracting the data for.

tgriffin

 

[TomSark]

It's substring( string, startpos, length (not ending position ))

+ is concatenation...

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[tgriffin]

Thanks for the correction Tom!