John Mitchell-245523 (4/5/2012)

---

Those decimals at the ends of the rows don't convert into datetime values, I'm afraid. But seriously, I really think full-text indexing is the way to go...

John Mitchell-245523 (4/5/2012)

---

No, INSERT statements. Many people won't bother to open a spreadsheet (may contain viruses), and of those that do, most won't have the time or inclination to...

A very big thank you Andy. I give it a go and get back to you. Many thanks:hehe:

Hi Andy, I tried this already but the users can search for say '1 bedroom at erith' and not just necessarily a word. Breaking the search down now, Erith might...

Ok, working on the inserts. THank you

Hi Andy, thanks for the advise. That just goes to show my newbie level!!!

Never used full text search but I'll look into it now and in the mean time I...

Ok Andy. Edited the post and extracted to an excel doc. Thanks 🙂

Hi Andy, thanks for you quick response. Here you go;

CREATE TABLE [dbo].[rhc_Properties](

[PropertyID] [int] IDENTITY(1,1) NOT NULL,

[AreaID] [int] NULL,

[StateID] [int] NULL,

[TypeID] [int] NULL,

[LocationID] [int] NULL,

[TransactionTypeName] [nvarchar](10) NULL,

[Price] [nchar](20) NULL,

[AgentID] [int] NULL,

[Description]...