Substr Function Problem

[mis03]

Hi Every One,

I am using Developer 2000 with SQL Server, when i am using SUBSTR function in Developer 2000 it accept, but in SQL SERVER this function not accept, the function is MID in SQL server or SUBSTRING like this, Is there any one who can help me in this mater, or is there any other function avail which can solve my problem.

Regards
Kamal.

[Orca777]

Hello;

I do not know much about SQL Server
But you could write a wrapper-function! ( a userdefined Function with the same Signiture ( Parameters )as the oracle-function)

Function Substr(,,,) -- SQL-Server Warpper-Function
BEGIN
MID(,,,);
END

Orca