Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Changing URLs in a SQL table
CREATE TABLE MyTable (URL varchar(255)) INSERT INTO MyTable (URL) VALUES ('http://value/value/value/value/value/value/value/value/value/MYVALUE'), ('1/2/3/4/5/6/7/8/9/10.pdf'),('1/2/3/4/5/6/7/8/9/13TEST.pdf') --SELECT right(URL, charindex('/', URL) +1) from MyTable SELECT right(URL, charindex('/', reverse(URL)) - 1) from MyTable
run
|
edit
|
history
|
help
0
Branch
dk
practice sql_12AUG_Upddated
program2
ankit
Loading json file into sql server
Task_3_Final
Left join producing wrong result
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers. #5
Demo