I've changed the quote value field to false and used a conditional as the value like
<@ifempty <@var something scope=local>> NULL <@else> <@var something scope=local> </@if> Charles Brown wrote: > The <NULL> vs just a blank field is not consistent in my MSSQL 2000 > database. Sometmes it enters the <NULL>, sometimes not. This is > causing a problem is a search action, which identifies the <NULL> and > the "blank" as two seperate values, so I get two or more rows returned > for the same individual. (My initial search brings back "unique" > individuals meeting the search criteria. A drill down link is provided > if the user wants to see all the activities associated with a particular > individual. The drill down still works for individuals that are showing > up more than once, but it is annoying to me and disconcerting to the > users.) Suggestions will be greatly appreciated. > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body -- Mike Tyranski Lynch2 p: 847.608.6900 f: 847.608.9501 http://www.lynch2.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body