I would like to know how to write a function that will go through data
in a column and change it. For example, I have a column of ISBN's for
books, and the ISBN's have a period in them randomly distributed. I'd
like to pull the period out.

Any help I can get will be appriciated.

Thanks,

On 18 Jul 2003 10:32:26 -0700 in comp.databases.ms-sqlserver,
[quoted text, click to view]

update mybooks set myisbn = Replace(myisbn,'.','')

--
Ride Free (but you still have to pay for the petrol)