Can a column in a rowset be changed?
- Posts: 1
- Joined: Fri Dec 11, 2009 9:22 am
- Support Specialist
- Posts: 66
- Joined: Thu Mar 05, 2009 3:49 pm
- Posts: 14
- Joined: Thu Jul 01, 2010 10:42 am
<setVariable label="Set sqlError" name="sqlError" value="0" version="1.0" />
<sql label="Connect to Server" resourceId="${ Server }" version="1.0" onError="setVariable:sqlError=1">
<query label="Get Doc Recs" outputVariable="DocRecs" whenNoDataFound="error">
<statement>
Select FirstName, LastName,
Case When upper( Suffix ) like 'JR%' Then 'J'
When upper( Suffix ) like 'I' Then '1'
When upper( Suffix ) like 'II' Then '2'
When upper( Suffix ) like 'SR%' Then 'S'
Else ' '
End as Suffix,
Address1, Address2, City, State, Zip, Phone
From MyLib.MyFile
Where MyField = 'MyValue'
</statement>
</query>
</sql>
-Rick