Aug 9, 2004 #1 prprogrammer Programmer Jun 25, 2004 49 PR I have a stings in db 7657575675H I want to delete a H....
Aug 9, 2004 #2 Nevermoor Programmer Jul 25, 2003 218 US Is H always at the end? If so, left(@String,len(@string)-1) should get you started Upvote 0 Downvote
Aug 9, 2004 #3 ESquared Programmer Dec 23, 2003 6,129 US Replace(ColumnName,'h','') ------------------------------------- A sacrifice is harder when no one knows you've made it. Upvote 0 Downvote
Replace(ColumnName,'h','') ------------------------------------- A sacrifice is harder when no one knows you've made it.