February 14th, 2004, 02:39 PM
Join Date: Feb 2004
Time spent in forums: < 1 sec
Reputation Power: 0
can someone help me with this ,,,,,
I have a table customer with the following fields
customerID is of the form Cxxxx, xxxx is numbers 0001-9999
custCat is string of three letters which specifies the type of customer..like spl(special), ord(ordinary) etc...
I would like to know if there is any way, I can get a combination of customerID and custCat as customerId when user makes a 'SELECT query.
I mean when user selects some records, he should see customerID as splC0001 or 'ordC8398' etc...even though customerID on database is Cxxxx....s
Please suggest any other solutions for this situation