Advertisement
SoWesley

Procedure Delphi Color with 6 positions

May 22nd, 2014
288
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1. CREATE OR ALTER PROCEDURE PRO_COR_6_POSICOES (COR VARCHAR(10), PREFIXO VARCHAR(1))
  2. RETURNS (RESULT VARCHAR(10))
  3. AS
  4. DECLARE VARIABLE STRAUX VARCHAR(10);
  5. BEGIN
  6.   STRAUX = REPLACE(:COR, '$', '');
  7.   STRAUX = REPLACE(:STRAUX, '#', '');
  8.  
  9.   IF (CHAR_LENGTH(:STRAUX) = 6) THEN
  10.     RESULT = :PREFIXO||:STRAUX;
  11.   ELSE
  12.   IF (CHAR_LENGTH(:STRAUX) = 8) THEN
  13.     RESULT = :PREFIXO||SUBSTRING(:STRAUX FROM 3 FOR CHAR_LENGTH(:STRAUX));
  14.  
  15.   SUSPEND;
  16. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement