1> -- SUBSTRING(string_to_remove_string_from, start_position, length) 2> SELECT SUBSTRING("www.java2java.com www.java2java.com",20,7) 3> GO ------- java2s. (1 rows affected) 1>