paste your real full Select statement here...it looks like you have a column name with a space in it, so it needs to be wrapped in brackets, ie [commision cost]

your order by has to be the same...simply order by the same casting you did to get teh field itself:

ORDER BY Tools.UUCBIM, cast(Tools.JOBNOF as varchar(12)), Tools.FITEMF

everything you posted (that showed up...some stuff got snipped out)

was related to a RTF field being justified. Are you trying to do the equivilent to raw text, or asking...

wouldn't you simply identify the offending rows like this?

SELECT *

FROM YOUR STAGINGTABLE

WHERE isnumeric(col1) = 0

OR isdate(col2) = 0

OR len (Row1.col3)>...

yeah replace"big query here" with your full SELECT...CASE...WHERE... statement that you are using...you had pasted just the cASE section as your example.

Oh, I'm sure I've got tunnel vision on the issue, instead of understanding....my knee jerk reaction was that an IF statement would automatically void schemabinding, but that's clearly not...

it's not obvious, but what you want to do is stick your query into a subquery, and use the where statement outside:

[font="Courier New"]SELECT MySubQueryAlias.*,

(MySubQueryAlias.New_Sell_price2

- MySubQueryAlias.commision_cost)

/ MySubQueryAlias.New_Sell_price2 AS MYRESULTS

  FROM...

well it doesn't complaina s i expected it to;

here's the way i thought it had to be, and then the way it thought would not be allowed with an "IF"...

i ended up doing it a different way...i got a sub select of all default values cross joined against the customers, and then used a COALESCE to get the updated...

Matt that's interesting, i didn't know about WITH SCHEMABINDING to a function...

does the results have to come from a SELECT statement in order to be deterministic?

I'd assume that an IF...

I'm watching for better answers, but this is how i understand it:

suppose you had a table with every address in the united states...200 million or so.

any search is going to...

i would not put the counter_id data in the table...instead i would make a view which had the value you were looking for:

[font="Courier New"]

SELECT      Row_number() OVER (PARTITION BY x.chk_no ORDER...

I'd tripped over the same issue previously.

ok, really you only need to search columns that are of type varchar,char,nvarchar and ntext....you obviously wouldn't need to search a numeric field for...

truncation implies that x number of characters of a string are not being saved....that wouldn't happen to a number(int for example)

do you mean decimal information? the definition for your columns...

i don't know if you'll find it;for the indexes on all the PK's and UQ indexes, you can find it because the creation date of the PK and it's index...