Query to remove symbols when ran

[KenshiroUK]

Hi all I'm looking for some code to delete * from both start of an order ID and end of order ID currently it looks like this *23627367236327*. I want it to look like this : 23627367236327

row is currently called order-id.

 

[bob fitz]

MAKE A BACKUP.
Then try:
UPDATE YourTable SET YourTable .[order-id] = Mid([order-id],2,Len([order-id])-3);

as the SQL of a new update query. You will need to change YourTable to the name of your table.

 

[KenshiroUK]

No no I don't want to actually update the table, when I run the select query I just want it to not include the asterisks.

 

[bob fitz]

Try:
SELECT Mid([order-id],2,Len([order-id])-3) AS Expr1
FROM YourTable;