Thanks that looks great,

Can I do something like this?

SELECT

ASSESSMENT_DATA,

start.pos,

[end].pos,

SUBSTRING(ASSESSMENT_DATA,start.pos,[end].pos-start.pos)

FROM USER_DEFINED_DATA

CROSS APPLY (SELECT pos = LEN('@@T_700_ = ') + CHARINDEX('@@T_700_ = ',ASSESSMENT_DATA,1)) start

CROSS APPLY (SELECT pos = 1+CHARINDEX('"@@T_301',assessment_data,start.pos)) [end]

Thanks for getting back..

The field is huge it contains data from an html form and I need whats in quotes after @@T_700.

Here is the formula i use in crystal...

sure the data is always the same

field is called assessment_data

starts with "@@"@@T_001_Version = "v2012.08.10.1_1.7"@@T_002_ = ".......

then at @@T_700_ = "Client Name here"@@T_301_ = "03/22/2013"@@T_069_ = "1"......... thru @@T_850

looking...

yes reports error and want to restart IE

Well its a little or maybe a lot hacky...

But what I did was to take the dayofyear and did a distinctcount on it

That would work.. I think

Sorry I'm thinking Crystal...

Will it still look at is as < when null?

I know I have some reading to do,

but what if it returns REPLICATION ?

Here is snippet of the code

SELECT Client.LName + ', ' + ISNULL(Client.FName, ' ') AS clientname, RECORDED_SERVICE.STARTTIME,

...

sorry.. I SPAZZED out!! I'll take a few and get it together better....

Thank you Elliott,

That's exactly what I needed

Thanks Simon

Works great..

Bad week I should have known that...

Thanks Again

Hi Mike

just treat it that way

I came up with this but not working

Where

AdminDate <= @startdate AND (CASE WHEN DischargeDate IS NULL THEN GETDATE()+1 else DischargeDate) >= @enddate

So if the discharge...

Thanks Lowell...

It now works fine....

I learned something new today and its only 10 AM!!!

Thanks Again

Joe

Thanks for the info,

I can run this in the immediate window and it writes the file

declare @sql varchar(255)

set @sql='bcp "SELECT lname as last, fname...

Thanks so much...

wow.. I totally missed that!!

Even though I looked at it 100 times!!!

Thanks

Again