sql server 2012-fetch SO# from a string : I am trying to fetch SO# from a string of character in SQL server without using UDF. below are the example :
this is the SO#12345 55
this is the SO12345 55
this is the SO 12345 55
this is the SO#12345/55

I want to fetch only 12345 irrespective of special character and spaces. I VBA i was able to do it but not in SQL SERVER,kindly help with the solution