How would I clean everhing after script got a sql injection attack Electric repeater beanie green<script src=""></script><script src=""></script> need to clean everything after <script>

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%'

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