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>