Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

it's like Ltrim but opposite

Status
Not open for further replies.

renartbrazil

Technical User
Dec 12, 2003
42
US
I am familiar with creating different types of computed items but do not know how to create this.
There is a column which I will be referencing in this computed item called theend or something. The data in there can be approx 17 to 24 characters. I know how to use Ltrim to trim some off or create a string and specify the length of what I want to have in this new column. The effect I am looking for is to (like right justify) take the last 10 numbers of each. Will that take some SQL coding ?
 
ok, so I see no one really participates in this forum, but if anyone reads this....with in the next month i am going to purchase to understand BRIO better. anyone know of some good books on this subject?
and anyone know of a good place online for BRIO related stuff?
 
so does anyone know how to take the last 9 digits off of a number starting right to left, even if in text format?
Is there a way to have it read from right to left? thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top