Thanks Imu92 for the detailed solution. Sorry I haven't replied before now, but I too have been out for the Holiday. Clever idea of how to work with...

OK...thanks for the suggestions, but I'm still not sure how to achieve the desired output...which in my case would be to manually create an HL7 interface message using T-SQL. ...

OK...those are definately some ideas that I hadn't thought of...I'll give them some thought. Obviously my net goal is to make this something that isn't a pain in the...

Ian...

When I try

I get the following:

"ÞþG‡¬-CQ½¦ÿÊÌ"

and I'm not sure what that represents!

One other note, I'm pulling these Hex values from a field within a SQL table, so...

Thanks Dave, the 'CHARINDEX' function did work. I had looked at it in the beginning of my search for a solution, but for some reason I didn't think it...

I really like Jeff's method of Tonsil removal...painful!!

But like he said, this isn't a very fair txt file. In the past, I've used products like Monarch to extract data...

Sorry for being so vague. I have files that I receive weekly that are text files. I want to compare these text files to the table in SQL,...