Recent content by Charlie2

How then How are we expected to validate then?It seems like there are a thousand and one formats

Ok Like"[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][A-Z][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][0-9][A-Z][0-9][A-Z][A-Z]"Or Like"[A-Z][0-9][A-Z][0-9][A-Z][A-Z]" Are you sure these are valid postcodes?

Erm Like"[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][A-Z][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][0-9][A-Z][0-9][A-Z][A-Z]" I don't allow spaces in my DB sorry

Solved: Like"[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"Or Like"[A-Z][A-Z][0-9][0-9][A-Z][A-Z]"

Upsizing Input masks don't get upsized to MSSQL but check constraints[Validation Rules] do, they haven't when I have tried upsizing DB's before.

Problem Anyone know what's up with this ? My existing data is regarded 'invalid' when I add the or condition?

Looks like Looks like I am sticking with Like "[A-Z][A-Z][0-9][0-9][0-9][A-Z][A-Z]"

I have searched the forum for posts on the subject of UK postal code validation and found the reg expression that seems to be recommended for this. I tried the expression but it will not accept this postal code? TS183AM Like "(?:(?:A[BL]|B[ABDHLNRST]?|" &...

Gracias Thanks man

Hi, I have built a query which works fine in access. The thing is I now want to use the same query in MSSQL 2000 and the synatx is wrong. I have tried altering the syntax myself but i am unable to get it to work. Can anyone show me how? Access Syntax: SELECT DISTINCT Holiday_Bookings.ClientID...

Ah Got it Will the currency formatting apply to any upsized data to MSSQL 2000?

Thanks Man That works great, but can you tell me how to format the result into currency, sorry to be such a dummy it's quite a while since I used this stuff.

I have developed a query which adds accumulated costs for each client in my DB, I am having trouble adding the VAT tax which is 17.5% to the query though, I seem to get a lesser total once tax is added which can't be correct. Here is my query: SELECT DISTINCT Holiday_Bookings.ClientID...

Sorted Ahh I think I have sorted it out. Thanks again Pat ;) SELECT DISTINCT Holiday_Bookings.ClientID, Holiday_Bookings.Booking_Cost, Room_Facilities.FacilityCost, Rooms.BasicCostPerNight FROM Holiday_Bookings RIGHT JOIN (Room_Facilities INNER JOIN (Hotels INNER JOIN Rooms ON Hotels.HotelID...

Thanks I have altered my query to remove the unneeded tables and now I get 6 results instead of one. I am puzzled. SELECT Holiday_Bookings.ClientID, Holiday_Bookings.Booking_Cost, Room_Facilities.FacilityCost, Rooms.BasicCostPerNight FROM Holiday_Bookings, Room_Facilities INNER JOIN Rooms ON...