R
Rab
I have a field that is alphanumeric and contains two types of claims data
auto and workers comp. The claim number field has claim numbers that start
with either AUXXXX for auto and WCXXXX for workers comp. Is it possible to
only count the auto claims by designating the alphanumeric format in the
count function? The query I am using was created by combing the two sources
(auto and wc) into one table by location.
auto and workers comp. The claim number field has claim numbers that start
with either AUXXXX for auto and WCXXXX for workers comp. Is it possible to
only count the auto claims by designating the alphanumeric format in the
count function? The query I am using was created by combing the two sources
(auto and wc) into one table by location.