PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WEBDEV 2024 → [07/19/2007] Did you Know ?
[07/19/2007] Did you Know ?
Started by The Free Technical Support, Jul., 19 2007 7:07 PM - No answer
#1
Posted on July, 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
→ Go back to WEBDEV 2024