2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by freshfitz
0

To strip everything following the first instance of '<script', you could use something like this.

update temptable 
set tempfield = LEFT(tempfield, charindex('<script', tempfield, 0) - 1)
where tempfield like '%<script%'
0

I get Argument data type text is invalid for argument 1 of left function

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.