PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WEBDEV 25 → [07/19/2007] Did you Know ?
[07/19/2007] Did you Know ?
Iniciado por The Free Technical Support, jul., 19 2007 7:07 PM - Sem resposta
Publicado em julho, 19 2007 - 7:07 PM
Hello,

WinDev, WebDev and WinDev Mobile provides SQL function overlapping.

The LEFT, RIGHT, MID, SUBSTRING, etc. functions can accept expressions instead of a string or numeric type value within the different parameters.

For example, to retrieve the domain name of an email address:

SUBSTRING(email, INSTR(email,'@')+1)

You will find all the details on these functions in WLanguage's online help in the "SQL, SQL Functions" section.


---
Best regards,
The Free Technical Support