Update Query

[gfranklin]

I need to run an update query to remove the dash - from the end of my column data but I'm unsure of the syntax

example of the data: 980890121-
239451-
4865000-
The lengths of the data in that column are not the same size which makes it difficult for me being a beginner to
SQL. Any ideas of how to do this would be greatly appreciated.

Thanks, Gabby

 

[redlam]

Try this...
update mytable
set myfield = left(myfield, len(myfield) -1)

This assumes that the dash is always in the last position.
Make a backup first, just in case

 

[pankajv]

Use Replace Function:

UpdateMyTable
Set MyField = REPLACE(MyField,'-','')