omit part of the field - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

omit part of the field

Author

Topic

a.ashabi
Posting Yak Master

117 Posts

Posted - 2009-01-05 : 16:45:01

Hi.I have a table with diffrent values like this:
14280_aljuc_1.jpg
14280_aljuc_3.jpg
14280_LBL.jpg
14280_SUP.jpg
100_Fkidbld_3.jpg
110_Fkidbld_1.jpg
1001_Soothing_1.jpg
10100_Half_1.jpg
...

if there is a middle part I want to delete that.which means I need to have these results:
14280_1.jpg
14280_3.jpg
14280_LBL.jpg
14280_SUP.jpg
100_3.jpg
110_1.jpg
1001_1.jpg
10100_1.jpg

thanks

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-01-05 : 19:11:46

Duplicate post, answered in New To SQL Server forum

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources