spaceplanner

asked on

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

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:

CW~02

PUNE 01~base

LN\CS~UB2

NY,1525~10

If we were to use the tilde ~ symbol would this have any implications?

We would have data in the table like this:

CW~02

PUNE 01~base

LN\CS~UB2

NY,1525~10

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
no problem at all.

Not probs

But you should not allowed to user to can insert data with tild operator.

But you should not allowed to user to can insert data with tild operator.