Table of ContentsPreviousNext

Ispirer             Ispirer


Ispirer SQLWays Database Migration Software

Conversion of Microsoft SQL Server Functions Returning Part of String to Oracle

a) Converting the RIGHT function.

SQLWays converts the Microsoft SQL Server RIGHT function to the Oracle SUBSTR function with negative length parameter.

TABLE 59. Converting RIGHT function
Microsoft SQL Server
Oracle
RIGHT (`ABCDEF',5) 
SUBSTR (`ABCDEF',-5); 

b) Converting the LEFT function.

SQLWays converts the Microsoft SQL Server LEFT function to the Oracle SUBSTR function with the start position 1 and the same length as defined in the LEFT function.

TABLE 60. Converting LEFT function
Microsoft SQL Server
Oracle
LEFT (`ABCDEF',5) 
SUBSTR (`ABCDEF',1,5); 


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.