I am importing ASCII data into SQL 7.0. The data has a record delimiter (the pipe character) and CR/LF is the record delimiter.

I need a way to ignore the final pipe character. Any ideas?

Would you also send your response to bbyrd@merklenet.com?

Thanks, Bob