Re: [U2] MS-SQL Question

2012-01-03 Thread Morelli, David W.
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

Re: [U2] MS-SQL Question

2011-12-29 Thread Brian Leach
/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

[U2] MS-SQL Question

2011-12-28 Thread George Gallen
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

Re: [U2] MS-SQL Question

2011-12-28 Thread David Jordan
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

Re: [U2] MS-SQL Question

2011-12-28 Thread George Gallen
...@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

Re: [U2] MS-SQL Question

2011-12-28 Thread David Jordan
...@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

Re: [U2] MS-SQL Question

2011-12-28 Thread George Gallen
...@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

Re: [U2] MS-SQL Question

2011-12-28 Thread Don Verhagen
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