beautiful! thank you.. 1 more question please..

In notepad++, there is anothor blank row with a CR..how do I remove that in sql studio?

|Literal||Free Text|

1021276||HBBCKGRND||Refund Check Sent|4681419, 2100027, 14841.77, 06/03/2015, Refund...

thank you guys but I noticed when I opened up my query in notpad ++ it shows carriage returns (CR) in the file.

for example,my ouput is below (i added the...

my query

DECLARE @Curr_Date DATETIME;

--Set @Curr_Date = CURRENT_TIMESTAMP;

set @Curr_Date = '2015-06-03 00:00:00.000'

SELECT RTrim(c.REFERENCE_NO) + '|', 'HBBCKGRND' + '|' AS Literal , 'Refund Check Sent', RTrim([DESCRIPTION]) + ', ' + LTrim([TRANS_NBR])...

DUH!!!! wow what a newb move I made lol. Thank you so much, thats what I needed!!!:w00t:

What do you mean by UI? User Interface? I am using microsoft sql management studio.

Heres my code, at the end I am only looking for active accounts. So in my...

I still have my training wheels for SQL, I never used those commands before. Can you please show me how I would use it?

*I like your signature lol