Re: SELECT substring of column into a variable

2005-04-30 Thread itrabado
<[EMAIL PROTECTED]> Enviado por: [EMAIL PROTECTED] 29/04/2005 20:38                 Para:        ActivePerl , Perl-Win32-Users@listserv.ActiveState.com         cc:                 Asunto:        SELECT substring of column into a variable What I'm trying to do looks something like this: SEL

Re: SELECT substring of column into a variable

2005-04-29 Thread Craig Cardimon
ct: SELECT substring of column into a variable What I'm trying to do looks something like this: SELECT substring(ContractTerms, 0, 1000) "$ContractsTest_ContractTerms" FROMContractsTest WHERE refnum = '1' I'm using Perl 5.8.6.811 on Windows XP Pro. I'm using

SELECT substring of column into a variable

2005-04-29 Thread Craig Cardimon
What I'm trying to do looks something like this: SELECT substring(ContractTerms, 0, 1000) "$ContractsTest_ContractTerms" FROMContractsTest WHERE refnum = '1' I'm using Perl 5.8.6.811 on Windows XP Pro. I'm using Win32::ODBC to connect to a SQL Server 2000 database. I'm printing out the res