I have a name field that has last name, a comma, and then a first name. Is there a way to split this to an array in SQL Server?<BR>thanks<BR>
An array in a database? Why not just make them two fields?
Run a VB Script on the database to split out the name into a usable structure...<BR><BR>You might be able to create a view using the left() and right() functions, but EEK! slow...<BR><BR>-- Whol