First Of All :)

[m3nf]

First of all i like to say hi to you all, i also like to ask for a little help.

I have a sql database with say.... a url in it http://www.blar.com as a record within a entery

How could i make all the enteries with http:// in that table only be changed to just www.blar.com

So that its removes the http:// part of it.


Thanks to all that help.

[Phil Weber]

What type of database is it (e.g., Access, SQL Server, MySQL, etc.)?

[alghrair]

Hi,
first of all, you have to know the length of your field.
then try this statment

e.g: your field name is URLName


Update YourTableName Set URLName = SubString(URLName,8, FieldLength)



That's statment will replace your field by removing the first 7 character.


thanks and best regards,
Al-Ghrair:rolleyes: