X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 83BD7475AD4 for ; Mon, 17 Feb 2003 15:47:16 -0500 (EST) Received: from axiontech.com (unknown [216.52.172.74]) by postgresql.org (Postfix) with SMTP id A82AB475A8D for ; Mon, 17 Feb 2003 15:47:15 -0500 (EST) Received: (qmail 20849 invoked from network); 17 Feb 2003 20:47:06 -0000 Received: from pc-00132 (HELO yudie) (192.168.1.132) by mail.axiontech.com (192.168.1.6) with SMTP; 17 Feb 2003 20:47:05 -0000 Message-ID: <009c01c2d6c6$fb985b90$8401a8c0@yudie> From: "Yudie" To: Subject: Format Function Date: Mon, 17 Feb 2003 14:56:01 -0600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0099_01C2D694.AFE1CD30" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/386 X-Sequence-Number: 11784 This is a multi-part message in MIME format. ------=_NextPart_000_0099_01C2D694.AFE1CD30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Is there any default function for formating string in postgre sql? for instance: Format('123ABCDE', '####-###-###') =3D> '12-3AB-CDE' The closest function I know is the to_char() function but it only works for= numbers please advise Thanks Yude ------=_NextPart_000_0099_01C2D694.AFE1CD30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

Is there any default function for formatin= g string=20 in postgre sql?

for instance:
Format('123ABCDE', '####-= ###-###')=20 =3D> '12-3AB-CDE'

The closest function I know is the to= _char()=20 function but it only works for numbers

please advise

Thanks

Yude

------=_NextPart_000_0099_01C2D694.AFE1CD30--