Atouray
asked on
getting the last three characters
I want to query to a table to get the salary of an employee then match this salary figure to another table called categories, if found i should take for example let's say the a employees salary is $5000 and after searching through the categories table and found a matching value and the corresponding category to this value is managing director 8.9. What i need to do is pick the value corresponding to managing director 8.0 which is the basic entry for managing directors.
I can get the employe salary and also i am getting the category but getting the value of the basic entry is the problem. The basic entry is always X.0 where X is a variable. Can someone help me on this please?
I can get the employe salary and also i am getting the category but getting the value of the basic entry is the problem. The basic entry is always X.0 where X is a variable. Can someone help me on this please?
Steve Bink
If you type it as an integer, the decimal portion will be dropped.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok i am getting the three digits right. But now after getting the digits that is after getting 8.6 and cast type it to 8.0, i am to concatenate it from the original string i got it from, for example "managing director 8.0" Any idea how can do this.?? I have different categories not only managing director.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.