this CLR code is really nice, and something i have on my dev server:
http://www.simple-talk.com/sql/t-sql-programming/clr-assembly-regex-functions-for-sql-server-by-example/
for the expression itself, it looks very close to the format for an ip address;
take a look at the example here for IP Address:
http://www.regular-expressions.info/examples.html
but i think it will be something like \bV\d{1,3}\.\d{1,3}\b to matc a 2 part verison name like V3.40
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!