• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

Select statment - first 3 letter

I have a column call confirmationnumber. How can I use Select statment to get only the first three letter in this column? I am using SQLexpress.
0
VBdotnet2005
Asked:
VBdotnet2005
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
select left(confirmationnumber, 3) from yourtable
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
select left(confirmationnumber, 3)
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now