hi frd. my function is increate like this value S0001,S0002
CREATE FUNCTION [dbo].[CUS_ID]() RETURNS VARCHAR(100)
BEGIN
DECLARE @maxid VARCHAR(50),@newid VARCHAR(50);
SELECT @maxid=max(xcus) from caxcus;
SET @newid= REPLACE(@maxid,'S','0000')+1;
RETURN 'S'+
CASE
WHEN LEN(@newid)<4
THEN REPLICATE('0',4-LEN(@newid))
ELSE ''
END +
@newid
END;
THIS FUNCTION I WANT TO CONVERT INTO MYSQL
THANKS I NEED SOME HELP.
Go to the complete details ...