PAD - thanks.. it worked!

Carl ~ thanks.  Your solution worked PERFECTLY!!!

-bt

You all have been more than helpful.  Question ~ when you mentioned 'Dont Forget 'IF' and 'TF' --- should I simply modify

((a.xtype='P' or a.xtype='U' or a.xtype='FN' or a.xtype='V')

to look...

Thanks for the responses.  Your replies helped me perform the following:

On Ent Mgr, I select PROPERTIES for the registered server name, then I selected the SERVER Properties tab and Checked the "allow...

well, the .Net developer replied that he is going to TRIM the column.

Works for me.  (thx folks!)

GOVIN - the schema and sample data are listed as the first entry (at top of this page)

I wound up using CURSOR processing to accomplish this:

--Declare/Open/Fetch/Close/Deallocate CURSOR sample

declare @OrderID int, @ResetID1 int, @ResetID2 int, @OrderItemID int

declare OrderItemTaxCursor cursor for

 select OrderItemID from...

Yes, I need all Persons w/ OR w/out an Application

Likewise, all Persons w/ OR w/out a Certification row 

thanks!  that worked great

I should have clarified a little further…

I need to do something like this, I think…

SELECT...

thx all. Problem resolved!

THANKS Phil!   I followed your recommended thread, found a pre-written proc, implemented it across a half-a-dozen jobs as the 1st step, and all is working great.

Much appreciated.

Bill

Yelena - it worked for me.  (w/ the dozens of GO statements embedded throughout the script)  I too was surprised that it completed successfully.

I encountered another new format:  MMYY.   (w/ a period as the 5th byte)  The actual data value in the column is "1101."  Can you help me format this one?  I've...

Just found my problem.  It works ok for some of the MM/YY values and doesn't work for others.  (probably the internal hex representation varies though the display looks like MM/YY)...