Manipulating strings

From: <patcyr_at_my-deja.com>
Date: Wed, 03 Nov 1999 15:15:53 GMT
Message-ID: <7vpjj3$v3o$1@nnrp1.deja.com>

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. Received on Wed Nov 03 1999 - 09:15:53 CST