Posted by --CELKO-- on 10/12/05 01:17

CREATE VIEW Parts (.., generic-part, ..)
AS
SELECT .. SUBSTRING part_id,1,5) + '_'[ + SUBSTRING part_id, 7, 1) ,
...
FROM Inventory;

• Next in forum: Re: Display Money Type using + and -
• Prev in forum: Re: Changing the 6th character of a string?
• Thread view: Re: Changing the 6th character of a string?

[Reply to this message]