CREATE PROCEDURE [dbo].[AP_getcustcode] AS BEGIN RETURN SELECT dbo.lpad( ( select max(cust_code)+1 from customerinfo ), 15, '0' ) ============================================== SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO CREATE FUNCTION [dbo].[GetCSContactSeqNew] ( @CustCode char(15) ) RETURNS char(3) AS BEGIN declare @id char(3) SELECT @id = dbo.LPAD( ISNULL(MAX(CSCON_CODE)+1,1), 3, '0') ..