PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 27 → [07/19/2007] Did you Know ?
[07/19/2007] Did you Know ?
Débuté par The Free Technical Support, 19 juil. 2007 19:07 - Aucune réponse
Posté le 19 juillet 2007 - 19:07
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