나츠's Document :: [DB2] LPAD, RPAD (REPEAT)

SQL2010/09/15 11:02

[DB2] LPAD, RPAD (REPEAT)

2

SELECT  REPEAT('*', 6 - LENGTH(RTRIM('LPAD')) ) || 'LPAD' AS LPAD
  FROM  SYSIBM.SYSDUMMY1
  WITH  UR

SELECT  'RPAD' || REPEAT('*', 6 - LENGTH(RTRIM('RPAD')) ) AS RPAD
  FROM  SYSIBM.SYSDUMMY1
  WITH  UR

Posted by ShiinaTsu

TAG DB2, Dummy, IBM, lpad, repeat, rpad, 더미

Trackback 0 Comment 0

«이전 1 2 3 4 다음»

ShiinaTsu

@_nts

Interest (4)

iPhone (1)

Mac (1)

SQL (1)

Twitter (1)