Arrays in stored procedures

[VBXL]

Hi

Is it possible to create an Array in a stored procedure

i.e Delcare example(1) as array

Xplain

 

[tlbroadbent]

No. There is no array variable. Many programmers pass a delimited string to a SP thus simulating an array. Check the following links for SQL code to parse a string.

http://www.sqlteam.com/item.asp?ItemID=637

The following link has at least three parser scripts that you can download.

http://www.swynk.com/sqlscripts/misc7.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.