I do not know Pervasive DB, but can you show us an example of the date_booked data?  Maybe conversion to varchar, then datetime will solve your problem.

CONVERT( datetime, CONVERT(...

R. Stewart's post piqued my interest and so I too took a look at your site.  I must admit, as a dyed-in-the-wool American (with Irish roots

War of the Worlds just opened.., I would guess that is the cause.  The aliens from Scientology (sp) are coming back....   

Writing or creating the update can be easier than it may seem. 

This is a script with known errors and is provided simply for an idea of how to approach...

That's a pretty good idea.  Having done this kind of thing before, it really is a booger to strip out the correct information. 

I would seriously give andrewkane17's suggestion thought. ...

Here is a function from one of the members of this site.  Once you figure it out, you should be able to reverse to only get the letters rather than...

Exactly correct.  You will want to use Flow Control to accomplish this: 

IF EXIST( SELECT TOP 1 IdentityField FROM Table WHERE @IdentityField = Identity)

BEGIN

          UPDATE

END

ELSE

BEGIN...

I would suggest reading BOL for IDENTITY properties.  You can use this: 

SET IDENTITY_INSERT tablename OFF

but if you duplicate a value, you will have serious problems when you set it...

I would recommend you store the data as smalldatetime or datetime.  You may want to inevitably do calculations on the SQL Server side as more data is entered into your...

If ORDER BY 1 is not supported, what replaced it?  Specifying the column, (or in this case, the display) data directly?  

Its a Group Number.  I did not know SQL Server could do that!  Thanks Vasc

Did not realize you had already posted...

I still don't understand how the first 1 (one) and only that parameter is being passed into the SP.  Any help? 

I proved myself wrong: 

CREATE TABLE Employees( EmployeeID integer,

                                           City varchar(15))

INSERT INTO Employees VALUES( 1, 'Tacoma')

INSERT INTO Employees VALUES( 2, 'London')...

It doesn't hide it, it ends the statement.  ; is a valid character in SQL to end a line of code.  (That is one of the tricks involved in using...

I quickly threw together a weekly average.  Maybe this will help you figure out a ten day moving average. 

CREATE TABLE #Stocks( TradeDate datetime...