Using them together...

Select substring(title_id, 1, 2) as alpha convert(int, substring(title_id, 3, 4)) as numfrom titles

Previous slide

Next slide

Back to first slide

View graphic version