Jim Horn
asked on
Function to remove apostrophes ( ' ) from a string
Does anyone have a handy-dandy SQL2K User-defined function to remove any apostrophe's from a string?
SELECT @INSD_LAST_NAME = dbo.SomeFunction(pers.PERS _LAST_NAME )
FROM PERS_PERSON pers
WHERE blah blah blah
If pers.PERS_LAST_NAME is O'Malley, then @INSD_LAST_NAME would be assigned the value of OMalley.
TIA
Jim
SELECT @INSD_LAST_NAME = dbo.SomeFunction(pers.PERS
FROM PERS_PERSON pers
WHERE blah blah blah
If pers.PERS_LAST_NAME is O'Malley, then @INSD_LAST_NAME would be assigned the value of OMalley.
TIA
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER