1 Attachment(s)
How to put text inform of number?
I have database in Microsoft Access. I have field name "PLOT" and its is text datatype.. The current records I have in the field is a number for example 12323..12222 How I can put some text in front of this number for whole records. I have to fill the text TKSS in this field? For example
TKSS3851
TKSS3852
TKSS3853
TKSS3854
TKSS3855
............
Re: How to put text inform of number?
Something like
Code:
Select 'TKSS'+PLOT From SomeTable...
Re: How to put text inform of number?
Quote:
Originally Posted by szlamany
Something like
Code:
Select 'TKSS'+PLOT From SomeTable...
Where I have to write this SQL command in Microsoft Access ?My Table name is Pemilik