>codes tend to have dashes, periods and numbers that preclude the
>Full-Text search features of SQL Server
what if you replace dashes, periods, and numbers with some unicode
characters, and then try to use the ready made text search?
Or just replace 5.4-1 whith fivedotfourdashone?