criteria
David Morelli
Pacific University
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, December 28, 2011 12:38 PM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
It came back
/database/SqlRegularExpressions.aspx
Brian
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: 28 December 2011 15:51
To: U2 Users
Subject: [U2] MS-SQL Question
I'm querying a sequel server , I have a column
I'm querying a sequel server , I have a column in one table that the data is in
the form of X|Y|Z.
I have the following in my SELECT:
substring(colname ,charindex('|',colname)+1, charindex('|',colname,
charindex('|',colname)+1) - charindex('|',colname) -1) as PID
Is there anyway that I can
You should be able to just use PID in the where clause.
David Jordan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 2:51 AM
To: U2 Users
Subject: [U2] MS-SQL Question
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: Wednesday, December 28, 2011 3:04 PM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
You should be able to just use PID in the where clause.
David Jordan
-Original Message-
From: u2-users
...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 7:09 AM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
That didn't work because it is not a virtual column defined in the table
layout. What I did was Created a variable in my program that contained the full
string
...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: Wednesday, December 28, 2011 3:35 PM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
You created PID as a synonym in the SELECT statement, you should be able to use
it in the where clause. I am sure I have done that before in the past with SQL
Server
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
It came back with unknown column error. I'll have to play with it
again, it's possible I typed something wrong,
But at least for now, it's working the other way I set it up.
Thanks
George
-Original Message-
From: u2-users