Comma Separated Values

comparing variable to a field with comma-separated values

"m trying to compare a variable (@item) to a field which has multiple item numbers separated by commas. I've used "LIKE" and "IN" to no avail. I've also tried appending wildcard characters to the variable (@item2), which also hasn't worked. Full-text indexing is not activated on the DB (SQL Server...

Creating a CSV file to FTP

I just loaded Office 2007 and created a csv file which then was FTP'ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?

Create .csv file on IFS folder in AS/400

Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).