sql server function to finding model number in description field
Posted on 2013-02-04
I'm looking for a function that will determine that a 'word' within a description is a model number and return the 'word'
To determine the model, the 'word' should either have:
1) 4 numbers
2) number and character combination, regardless of how many numbers
"Canon PowerShot A230"
"A2300" is the model number because it has a character and number combination.
It likewise, would be a model if it was "2301"
I'm hoping that either someone has this code, or can write it quickly, and it would take me a while to figure out.