[AccessD] replace in blank (is Null) Field

yeah, sorry about that....realised as soon as I pressed the Send





Message date : Apr 29 2004, 01:07 PM
>From : "Stuart McLachlan" 
To : "Access Developers discussion and problem solving" 
Copy to : 
Subject : Re: [AccessD] replace in blank (is Null) Field
On 29 Apr 2004 at 12:43, paul.hartland at fsmail.net wrote:

> Pedro,
> Can't you use Replace(YourField,"",WhatYouWantToReplaceItWith) in a loop
> Paul
> 
Unfortunately, "" ( a zero length string) is not the same thing as a 
Null.


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm