Hi Jeff,

Thanks again. I don't have the code with me at home but on tuesday I will post what i came up with. Got a bit complicated with unions and...

thanks jeff

I seem to be able to clean the most of them with the current query, i just end up with some rows where none of the data matched the...

The problem was caused when there were no properties in the property table, when I added a dummy property with dummy propertyimage it worked fine.

Thanks for your help.

P

I am having a problem with the insertion of the images.

The PropertyAddress field is a text field while the PrprtyAddr field is an varchar(255) when I do a cast it...

don't worry when i did the copy and paste it added a couple extra select statements

I get the following error when trying to Parse it:

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

All I changed was Property Table PK name which is ID

Any clues do I...

Thanks I will give it a try and get back to you