Can Fuzzy Logic be used with SQL 2000

[mikii]

Can fuzzy logic be used with SQL 2000? Thanks.

 

[gmmastros]

The simple answer is: it depends.

It depends on what you are trying to accomplish.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mikii]

I have addresses that I match to multiple tables. The script was created in SQL 2005 but now the client is using SQL 2000. I've never used SQL 2000 so I don't know if I can run the same script on 2000 tables. Thanks!

 

[gmmastros]

I have a SQL2000 server here. If you want to post the script, I could take a look at it and let you know. There were a lot of changes between SQL2000 and SQL2005, so not all scripts would be compatible. Often times, code that is not compatible with SQL2000 can be re-written to make it work.

Without seeing the code, it's impossible to say.

Your other alternative would be to install MSDE2000 (the free version of SQL2000) and then try running your code against it. You can use your SQL2005 Management Studio to connect to an MSDE2000 instance.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom