This Function Enables the user to retrieve the Last Index of the character/string in a predetermined string.
If you want search for the Last Occurance of 'SQL' in
'SQL SERVER2000 USES ANSI SQL' then
SELECT dbo.LastIndexOf('SQL SERVER2000 USES ANSI SQL','SQL')
Tested Only in SQL SERVER2000
For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.