parsing URL

[lan huynh]

let say i have a table in MS Acccess with two columns: URL_ID, Complete_URL.

for example:

URL_ID = 1

Complete_URL = 'http://www.mssqltips.com/tip.asp?tip=1226'



how do i write a query that parse 'http://www.mssqltips.com' into a new column?



Thanks for any help!

Lan

 

[Alex Dybenko]

Hi,
try such query:

select left(Complete_URL,instrrev(Complete_URL,"/")) from mytable

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


in message news:[email protected]...