thanks "is null" did it.
Daniel


At 07:50 PM 18/04/2001 +0100, you wrote:

>Try:
>
>update notesdata
>SET notetype = 'D'
>where notetype is null
>
>OR try this
>
>update notesdata
>SET notetype = 'D'
>where notetype = ''
>
>(ie, blank string not a space)
>
>
>Roger
>
>-----Original Message-----
>From: Daniel Bertin [mailto:daniel@...]
>Sent: 18 April 2001 19:27
>To: IBObjects@yahoogroups.com
>Subject: [IBO] help please IBO SQL
>
>
>Hi All
>With IB60 and IBO
>In IB_WISQL , DSQL tab, the SQL
>
>update notesdata
>SET notetype = 'D'
>where notetype = ' '
>
>execute statement
>post datasets and commit
>nothing
>Does not produce any errors and does not replace all blank notetypes with D.
>why is that?
>
>Help someone please..
>Daniel
>
>
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/