Thanks again to everyone who has helped me so far!
Now I'm back again with yet another question:
Is there any way to replace mulitple values in a string? I have a field containing phone numbers, with several different separators (some dashes, some slashes) and I'd like to replace these characters with nothing so I have a single continuous number. I know how to do one at a time using replace, but can I remove all the offending characters in one shot (in a select statement)?
(123) 456-7890 -> 1234567890 (removing parentheses and dash)
987/654-3210 -> 9876543210 (removing slash and dash)