SQL Script Development

Search - MySQL · local_filter_skipped · UID ~022076694994049350640

Open Job

Job Details

Budget Unknown

ExperienceIntermediate

DurationUnknown

Weekly hoursUnknown

Client countryUnknown

ProposalsUnknown

InterviewingUnknown

Invites sentUnknown

First seenMon, Jul 13, 2026 4:27 PM

Last seenWed, Jul 22, 2026 6:06 PM

Description

I am using Microsoft SQL Server 2019. I have a database table that contains a field called PictureLocation. It contains the location of picture files. An example of data in this field would be: https://www.website_name.com/directory1/directory2/picture_name.jpg. I need an SQL Script that will remove the URL and directories and leave only the filename in the field. So the only thing in the field would be the name of the file i.e. picture_name.jpg. I also need an SQL Script that will change any .png extension to .jpg inside of the PictureLocation field.

Skills

Microsoft SQL Server SQL

Notification History

Channel	Type	Status	Sent	Error
No notifications.

User Actions

Action	Acted at
No actions.