Computed Fields (continued)
{"Image DocumentName": "Computed Fields (continued)", "Image ImageDescription": "Numeric Computed Fields. Example 1: Computing the Net by deducting Credit Limit from Balance. SELECT Customername, (Balance-CreditLimit) as Net FROM Customer. Example 2: Computing the Running Total by Multiplying On hand quantity with Price. SELECT Partnum, Description, OnHand   Price as RunningTotal FROM Part. Non-numeric Computed Field. Example 1: Concatenating or Joining Last name and First name of the Sales as Full Name. SELECT Repnum, Lastname + , + Firstname as Fullname FROM Rep.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}