So, is there a way to get rid of the right two numbers to get 9998.00 ?

Of course this will work, but the question is that I already have a lot of procedures based on the same formula but never experienced such problem. So, I am a...

@startdate 31/7/05 and @enddate 1/8/05

This is the original function that returns no results as audit dates are on 1/8/05

Yes, because I looked into the data at the table level and date is set correctly and it contains time.

About the left function, it is working perfectly. I got it...

When I ran the procedure from query analyzer, I still get the same erroneous results.

I use the left function as follows Left(datetimefield, 12) and it gives the accurate results.

yes the data is consistent with period after title. No there is no comma between names and there are no records with more than three strings

Yes they always start with either Mr. Miss, mrs. but there is not a dot always. They are stored as title, lastname, firstname

Then how do you recommend  a solution for this issue as sometimes even the customer number may be 3 , 4 or five....

The main table is a service table that has a single servicerefno, we add to customers to the same service which carry the same servicerefno so it is one to...

I am creating a main table under which there are a lot of services (around 10) and each service also has some other linked tables. At the end I need...

The problem is I will be using this in generating a lot of other queries not just for presentation

This is because the id is a link field to a different master service table and that is why I need to generate pax list for that master service table

Unfortunately, this can not be done as the user must enter sometimes more than ten airports in one form and the way the airport codes are arranged makes it very...