Since T-SQL has no array data type, passing delimited strings is a great way to send a variable number of parameters to a function or stored procedure. This function behaves similarly to the VBScript function or Javascript String.split method. You pass it a delimited string and the delimiter where the split should occur. Returns a table data type as a psuedo array. I have added to my model database so a copy is made for all new DBs