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

Extracting data from query conditional

Experts,
I have a field with data (numeric) as follows:
10071957
08011958
09121985
In my query I need only those records where the first two digits in a field are = 09 or 08
0
Frank Freese
Asked:
Frank Freese
1 Solution
 
Rey Obrero (Capricorn1)Commented:

try this query

select *
from tablex
Where Left([fieldName],2) In ("09","08")
0
 
Frank FreeseAuthor Commented:
thank you!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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