I am new for CLR..
I want to achieve following criteria.
The format can be formatted as It can begin with V, E, or a number.
• If it begins with V, then it has 2 numbers, a decimal, then up to two numbers
Examples: V10.12 and V12
• If it begins when E, then it has 3 numbers, the decimal place, then up to two numbers
Examples: E000.0 and E002
• If it begins with a number, then it is up to 3 numbers, a decimal, then up to two numbers
Examples: 730.12 and 730
Will you please help me in creating regular expression in sql server, need to create CLR for that will you please create a regular expression CLR and I want one regular expression format supported by that CLR with above conditions