Thursday, June 14, 2012
SYBASE IQ - Split coma seperated values in to rows
To split delimiter separated values in to rows use sa_split_list function
Usage:
SELECT * FROM sa_split_list( 'Tee Shirt,Baseball Cap,Visor,Shorts' ); |
| line_num | row_value |
|---|---|
| 1 | Tee Shirt |
| 2 | Baseball Cap |
| 3 | Visor |
| 4 | Shorts |
For detailed intormation check Sybase Documentation.
0 comments:
Post a Comment