title: How do I extract part of a string in t-sql
body: <p>If I have the following nvarchar variable - BTA200, how can I extract just the BTA from it?</p>
  
  <p>Also, if I have varying lengths such as BTA50, BTA030, how can I extract just the numeric part?</p>