> I am moving a site from an Access DB to SQL Server 7.0 and have run into a
> function that was being used that is not supported in SQL Server 7.0 The
> function is: InStr([start, ]string1, string2[, compare]) Is there a new
> name for this function in SQL Server?
It's definitely CharIndex, but be warned that the parameters are around the
other way from InStr
If you use InStr extensively, be prepared for a lot of one-line re-writes.
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
