What would be the easy way to find this within my thousands of records, would you say?

The issue is that the sql is coming from an asp form that generates the code on the fly, so I checked the website that my software is from and...

Sorry I did mean a left outer join, I am trying to update these fields with in a view. I really dont see what the issue is, I am using...

Thanks for your reply, basically I have an asp form that contains fields from two tables. I am trying to add values into fields from tblasset and tblsites on my...

This code did execute I made a typo, but it doesnt work. Executes but made no changes ;( Any Suggestions

If I create a Unique Index this surely will only display All values with Nulls or Or records with No Nulls. Basically I want to place a constraint on this...

Tried the code above and got incorrect syntax near the keyword OF?

Thanks for your help, I will try it tonight and get back to you on how I get on.

Thanks for your suggestion, I am getting a conversion error as my field is NVarchar and not a INT type. Any suggestions?