Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Simple SQL question
Re: Simple SQL question [message #31386 is a reply to message #31373] Sun, 27 February 2011 09:19 Go to previous messageGo to previous message
koldo is currently offline  koldo
Messages: 3442
Registered: August 2008
Senior Veteran
Hello Mirek

For the question it could be used:

SQL.Execute("select *, [Name] || '.' || [Surname] || '.' || [Location] as FULLDATA from PERSONAS where FULLDATA like '%" + pin1 + "%' and FULLDATA like '%" + pin2 + "%'");


The '.' is just to avoid that "aryPop" would match with register MaryPoppinsBruxelles.

Is it possible to do this and use ALIAS with SqlExp or it has to be done with plain SQL?


Best regards
IƱaki
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: SQLArray + Like() + Accents problem
Next Topic: Demo Package of FieldOperator usage
Goto Forum:
  


Current Time: Sat Aug 02 19:22:17 CEST 2025

Total time taken to generate the page: 0.08384 seconds