nin

CREATE  FUNCTION Bestiban(acc varchar)
RETURNS varchar AS $$
DECLARE num numeric;
DECLARE DC varchar(2);
BEGIN
	SELECT CAST(replace(acc, ' ', '')|| '******' AS numeric) INTO num;
	SELECT LPAD(CAST(98 - MOD(num, 97) AS varchar(2)), 2, '0') INTO DC;
	RETURN 'ES' || DC || replace(acc, ' ', '');
END;
$$ LANGUAGE plpgsql;