thank you for making me feel like an old goat

ooops!

Totally agree.

My first use of Windows was with 3.0  and have worked on each version since (even...

Not that I am aware of.

The only way I can think of getting the severity is to query the master.dbo.sysmessages table.

Or

DateAdd(minute, -1440, GetDate()) 

OK, only kidding

1.

Create a table with single varchar column, concatenate (and cast where necessary) columns from each table into the varchar column. Extract the table into text file via DTS or OSQL (in DOS...

Personally I do what you described by creating a proc that updates a single row using key provided and call this many times from the app as required. This is...

CREATE PROCEDURE usp_Person_GetVisits

(

 @PersonID Varchar(30) = NULL

)

AS

SET NOCOUNT ON

SELECT visitType,

CASE WHEN visitType='I' THEN 'In-Patient' ELSE 'Out-Patient' END AS [visitTypeDesc]

FROM Visit

WHERE PersonID = @PersonID

ORDER...

Did you reapply SP4, had similar problems on SQL7 when I installed FTS after SP's applied and had to reapply SP to get FTS to work.

I reapplied SP3a on my...

Maybe

Besides if I posted it first time you'd have nothing to refer to  , then your posts...

So will

WHERE waccessno LIKE REPLACE('XXXXXXXXXX-XX-XXXXXX','X','[0-9a-z]')

and looks prettier and neater than yours

SELECT waccessno

FROM

WHERE waccessno LIKE '[0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z]-[0-9a-z][0-9a-z]-[0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z][0-9a-z]'

Create a format file containing the following

8.0

13

1       SQLCHAR       0       255     "\r\n"                        1     ACCTNUMB

2       SQLCHAR       0       255     "\r\n"                        2     LOCOPT

3       SQLCHAR       0       255     "\r\n"                        3     PAYAMT

4       SQLCHAR       0       255     "\r\n"                        4    ...

All nonaggregated columns in the SELECT clause must also be listed in the GROUP BY clause

If we're nitpicking :rolleyes: then....

Even though I got it correct I don't think it is...

Really I don't think so

You stated that a parent may be present but no child yet...

If that is the true text then sql will treat A,B and C as ignored words and you will only be able to use CONTAINS

select * from where CONTAINS(cl_name,...