In MS Access 2000 if I have a String such as:
Column1
Delta CC: 123
Charley CC: 234
Foxtrot CC: 890
and I wanted to extact just the numbers in to a field called CC
I could use this formula in a calculated field:
CC: Mid([Column1],Instr(1,[Column1],"CC")+3,50)
resulting in:
CC
123
234
890
Any idea on what the code should be within a view in SQL Server?
also -- what is a good reference that can help with these types of
problems.
Any help appreciated!
RBollinger