Troush2009
asked on
Need help with creating a update query
I have below query vbut it is not working.
I am trying to remove "-" and replace it with nothing.
I just want to remove "-"
UPDATE RBS SET RBS.FDN_REMAINDER = "-"
WHERE (((RBS.FDN_REMAINDER)=" "));
I am trying to remove "-" and replace it with nothing.
I just want to remove "-"
UPDATE RBS SET RBS.FDN_REMAINDER = "-"
WHERE (((RBS.FDN_REMAINDER)=" "));
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or with Null
UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"- ",Null)
WHERE (((RBS.FDN_REMAINDER)=" "))
UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-
WHERE (((RBS.FDN_REMAINDER)=" "))
Personally i would use
UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"- ",Null)
WHERE (((RBS.FDN_REMAINDER)=" "))
source for help on this
http://www.techonthenet.com/access/functions/string/replace.php
UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-
WHERE (((RBS.FDN_REMAINDER)=" "))
source for help on this
http://www.techonthenet.com/access/functions/string/replace.php
ASKER
LOL
UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-
WHERE (((RBS.FDN_REMAINDER)=" "))
mx