Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
SELECT sysCode || ' - ' || codeDescription AS CodeSelection FROM sysCodes ORDER BY sysCode
BR549 - Portable Light Retriever CC212 - West Virginia Nothing Grinder FB900 - Left-Handed Metric Adjustable Wrench VS829 - Radial Spectrum Weeble Balancer
in my normal SQL code and it matches the [whatsits] to the user-selected items; but not any more. I realize that the selections are an array, but need to somehow "strip off" everything past the the "-" (which I added in the SQL statement). That's the rub - if I can just get rid of the "-" and all of the information to the right of it, the list will re-match what appears in the [whatsit] column of the table.
WHERE whasit IN (:UserSelectedStuff)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.