How Do I Split A Column Result By A Nonalphanumeric Character?

I have a column that returns client numbers.

The client numbers are 4-6 characters in length.  A period (.) is added to the end of the client number, and then one last digit (1-4) is affixed at the end to denote a categorization.

In SQL, I need to figure out how to divide these results into two columns, one for the client number and one for the categorization number.

EG:  client #4334.1 would become 4334 for client # and 1 for categorization number

or

         Client #424561.3 would become 424561 for Client # and 3 for categorization number.

I have to strip out the period in the process and leave myself with just the numeric characters divided into two columns.

Ive been researching my brains out on string queries and substring queries and I can't figure out how to parse out the period and/or to have SQL understand that I need everything BEFORE the period for one column and everything AFTER the period for the second.

Is it possible to do this?  I really need help on this one.


Thank you :)