Thanks for the reply, im not even letting it get into the table yet, im just looking @ a preview of the data from the connection, and its showing nulls...

A little more information, we just cant seem to get a column that was once a date column in excel to show up in my import. The column right...

appreciate all the great advice, new to all the sql stuff, working on modifying some of the code, and will let you know the results, thanks for spending the time...

getting closer, how come it shows me the prefix twice in some cases:

--This will query and show all the account prefixes and total number of accounts in each prefix

select distinct...

quick question about the substring, i am running the following:

--This will query and show all the account prefixes and total number of accounts in each prefix

select substring(ad.account_number,1,2)as AcctPreFix, count(*) as...

appreciate that, i wasnt thinking, now i understand the substring is a function, not something i enter, thanks, great help

appreciate the quick reply, in the learning phase of writing sql, so dont laugh, but what do you mean by substring? list select *? and than i guess...