We are currently running SQL version 6.5 and are planning to install another application that requires SQL 2000 to be installed on the same server. May I know is it possible to have two version running concurrently and what are the things to take note?
I find that CHARINDEX does not seem to return the position of a matching phrase when the token being searched contains punctuation after the phrase. In other words CHARINDEX('Birthday', 'Hope you have a happy Birthday!', 0) does NOT return the position of Birthday in the phrase!!
I have one table with two columns, namely "SaleValue" & "SaleDate". A snap shot of the table is as follows: SaleValue SaleDate --------------- ------------