So I have a column in a table with varchar values. The values can look like "#12345 abcd" or "abcd #1234" (without the quotes). I want to pull out just the number from those strings of characters. So in other words if the field value is "#1234 abcd" i want to return just "1234". How can I do this within a select statement? Thanks.