From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
@VAR_ARRAY varchar(8000),
@VAR_SEPARATOR char(1)
AS
SET NOCOUNT ON
DECLARE @LOCAL_SEPARATOR_POSITION int
DECLARE @LOCAL_ARRAY_VALUE varchar(1000)
SET @VAR_ARRAY = @VAR_ARRAY + @VAR_SEPARATOR
WHILE PATINDEX('%' + @VAR_SEPARATOR + '%' ,
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
What I sent was for SQL Server... Sorry about that. See if somneone can help
translate it into PL/SQL.
Mike
~|
Logware (www.logware.us): a new and
hehe...thanks Michael...I though that looked like T-SQL ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
I gave the same snippet to a buddy last year who wanted it for Oracle. I
think he wount up using INSTR and didn't have to modify too much. Good luck.
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
hehe...thanks Michael...I though that looked like T-SQL ;-)
I tried sending a reply earlier but did not notice it coming through. I have
a function for something similar that you could probably modify for this. I
will plug it into a file and send it to you offlist.
On 8/5/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
hehe...thanks Michael...I though
5 matches
Mail list logo