Re: Manipulating strings

From: <michael_bialik_at_my-deja.com>
Date: Wed, 03 Nov 1999 20:57:56 GMT
Message-ID: <7vq7ki$e9k$1@nnrp1.deja.com>

Hi.

Try
SUBSTR(TO_CHAR(Code),1,3) || '-' || SUBSTR(TO_CHAR(Code),4,2)

HTH. Michael.

In article <7vpjj3$v3o$1_at_nnrp1.deja.com>, patcyr_at_my-deja.com wrote:
> Hello everyone,
>
> I'm working with visual basic 6.0 and I have a
> DBCombo that is automatically filled with two
> fields of one of my table. But I want my field
> Code, who look like '60010' to be shown like '600-
> 10'.
>
> Here's my code:
>
> dim ODyn as oraDynaset
>
> Set ODyn = objDb.CreateDynaset("SELECT Code, Code
> || ' ' || Name AS Expr1 FROM myTable ORDER BY
> Code", 0&)
> Set ORADC.Recordset = ODyn
>
> Result:
> 60010 XXXXXXXXXXXXXXXXXXXXXXX
> What I want:
> 600-10 XXXXXXXXXXXXXXXXXXXXXXX
>
> Can anybody help me?
> Thanks a lot!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 14:57:56 CST