Using tilde character ~ in data, will it cause problems?

Posted on 2006-03-23
Last Modified: 2008-03-03
We need to combine 2 pieces of data in one field. The data will not be regular expressions. Subsequently we will need to identify each piece of data within the field. We cannot use space  , comma , ,underscore _ , hyphen - , backslash\ and forwardslash /as separators.
If we were to use the tilde ~ symbol would this have any implications?
We would have data in the table like this:
PUNE 01~base
Question by:spaceplanner
    LVL 142

    Accepted Solution

    the tilde will not cause problems when in data
    LVL 7

    Expert Comment

    no problem at all.
    LVL 11

    Expert Comment

    by:Ved Prakash Agrawal
    Not probs
    But you should not allowed to user to can insert data with tild operator.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now