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.