SELECT on part of a column data

[Ruslan Zasukhin]

On 4/24/12 7:42 PM, "Stan Busk" <maxprog at mac.com> wrote:

Hi Stan,

> Is there a way to do a SELECT in part of the data contained in the columns?
> For example, if the columns is like "TEXT #number" or "TEXT number" and I want
> to do a SELECT on those numbers? Basically my problem is that by design a
> column contains both data and now I need to do a SELECT on the number only :-/
> Is that possible?

Table Methods  (aka Calculated fields)  can help I think.

You can see all possible functions for them
In the SQL EXPRESSION section

<http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:ref
erence:reference>


You can even build index by method if needed.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]