LEFT ( string , length )-> SUBSTR( string, 1, length )
PATINDEX ( '%substring%' , string )-> INSTR( string, substring )
CHARINDEX ( substring, string [ , start] ) -> INSTR( string, substring, start )
OBJECT_ID ( 'object' ) -> select object_id from user_objects where object_name = 'OBJECT';
|