I have the following (hopefully simple) SQL question. I have a field which holds the zip code in ZIP5-ZIP4 format. I would like to Select this field into TWO fields (one for ZIP5 and one for ZIP4). The two ZIP fields have a "-" between them. How do I do this?
How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.
We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…