help with sql statement doing substrings and replace
From: Figz <efeigenb_at_alumni.tufts.edu>
Date: 7 Mar 2003 12:40:48 -0800
Message-ID: <3758d0a5.0303071240.659a3f24_at_posting.google.com>
Date: 7 Mar 2003 12:40:48 -0800
Message-ID: <3758d0a5.0303071240.659a3f24_at_posting.google.com>
Hi,
I have columns called FILES with data like
FILES
and I want to find all the ones in that column that have '%.pdf' in
them and replace them with everything BUT the .pdf extension. So I
would end up with:
FILES
'hello.pdf'
'something.pdf'
'noextension'
'test01.pdf'
'anotherwithnoextension'
'hello'
'something'
'noextension'
'test01'
'anotherwithnoextension'
Can someone tell me a sql statement to do that? Thanks! Received on Fri Mar 07 2003 - 21:40:48 CET