Link to home
Create AccountLog in
Avatar of Metalteck
MetalteckFlag for United States of America

asked on

Reserved Blank Space in SQL delimited query

In my delimited query, I have certain fields that need to be reserved as a space.
Can I use '',1 to indicate a space of 1?

Or is there another way to correctly write it?
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Sean Stuber
Sean Stuber

or, depending on your database you could try something like chr(32)  to embed a space character
Avatar of Metalteck

ASKER

Thanks for the assist.
I will have other questions regarding oracle delimited queries.
Would love your help.
Some databases also support SPACE(x) which will generate a string of x spaces, so SPACE(1) would also work.  However, if you simply need a single space, then ' ' is the easiest to type and understand.
If your questions are about Oracle, then I recommend adding the Oracle Topic Area to your future questions.

You'll get a little wider audience and, more importantly, give the participants some extra information about which suggestions to make since different databases have different SQL syntax functionality.