Hi,

MSSQL 2000 question:

I need an SQL statement that would take e.g. "TAG/ 123456" and delete everything left of the forward slash giving me a result of "123456". I can not give a count as there are many values that may vary.

Select Replace(partname????????) from orders

Thanks