| non-numeric data. Unfortunately, the REPLACE function doesn't | appear to | accept wildcards, otherwise that looked promising. James, Did you catch the post on the LEFT and PATINDEX functions? <rory disposition="curious" alt="?"/>