Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

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)="  "));
0
Troush2009
Asked:
Troush2009
1 Solution
 
peter57rCommented:
UPDATE RBS SET RBS.FDN_REMAINDER = ""
WHERE (((RBS.FDN_REMAINDER)="-"));
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
try this:

UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-","")
WHERE (((RBS.FDN_REMAINDER)="  "))

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Or with Null


UPDATE RBS SET RBS.FDN_REMAINDER = Replace([FDN_REMAINDER],"-",Null)
WHERE (((RBS.FDN_REMAINDER)="  "))
0
 
James MurrellProduct SpecialistCommented:
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
0
 
Troush2009Author Commented:
LOL
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now