Determine the result of each of the function calls in the following questions. A

Question

Determine the result of each of the function calls in the following questions. Assume values for variables as follows: Name = '__Ann_Smith__' (underscore = space) NewValue = 4.743 NewDate = 2013-4-12 (no time part) OldDate = 2012-4-12 (no time part) 1. LTRIM(Name) 2. RTRIM(Name) 3. LTRIM(RTRIM(Name)) 4. SUBSTRING(Name, 3,3) 5. REVERSE(Name) 6. REPLACE(Name, 'Smith', 'Jones') 7. Round(NewValue,0) 8. ROUND(NewValue,1) 9. ROUND(NewValue,0,1) 10. ISNUMERIC(NewValue) 11. FLOOR(NewValue) 12. CEILING(NewValue) 13. ROUND(SQUARE(NewValue)), ,3) 14. DATEPART(year, NewDate) 15. DATEPART(month, NewDate) 16. DATEPART(day, NewDate) 17. DATENAME(month, NewDate) 18. ISDATE(NewDate) 19. DATEADD(year, 1, NewDate) 20. DATEADD(day, 5, NewDate) 21. DATEDIFF(day, OldDate, NewDate) 22. DATEDIFF(year, OldDate, NewDate) 23. Suppose you designed a database table for a client with a 50 character text field named ADDRESS. The client has added about 500,000 records to this table. Now, they want to be able to break the address apart for sorting, etc. How would you do this?

Explanation / Answer

1)Ann_Smith__

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.