• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Ltrim and rtrim usage...

Ricardo Paz

Reputable Poster
Hi list...
does anybody know how to use the rtim(,) and ltrim(,) text function on event
rules ???


OW B73.3.2 SP 10.1 / NT 4.0 Sp 6a/ SQL 7.0

S.E. Ricardo Paz Castañón
Systems Chief
Comercial de Herramientas S.a de C.v.
+52(8)369-35-35 ext. 286


Legendary Poster
Hi Ricardo,

Hmmmm..., is it the Developers List/Forum?

In response to your question:
rtrim = trim a character from the right of a string
(do you guess "ltrim"? :)
ltrim = trim a character from the left of a string
First parameter have to be a string type control, variable, etc. to trim from.
Second parameter is the character to trim.

evt_String_DESC = "xxxxABC"
evt_Char_EV01 = "x"
evt_String_DESC = ltrim(evt_String_DESC , evt_Char_EV01)

evt_String_DESC will contain now: "ABC"

Have a good ER coding,

(a visitor from the Developers Forum/List)

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)<P ID="edit"><FONT SIZE=-1>Edited by Zoltan_Gyimesi on 8/10/01 10:53 AM.</FONT></P>