ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Top Posters(30 Days)
Potseal 11
Recent Posts
Why cables look like they do
by LongRunner. 04/26/17 09:36 AM
Dimmable LED 2x4 lay in fixtures
by HotLine1. 04/24/17 05:43 PM
Old decora style outlets
by Lostazhell. 04/22/17 07:59 PM
Permit Snafus...AHJs and Contractors Jump in
by gfretwell. 04/22/17 01:11 PM
How do you find a good employee?
by HotLine1. 04/22/17 10:44 AM
New in the Gallery:
SE cable question
Popular Topics(Views)
234,758 Are you busy
169,516 Re: Forum
162,799 Need opinion
Who's Online Now
0 registered members (), 53 guests, and 9 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate This Thread
#132072 - 02/20/05 04:25 AM SQL and Database help  
Gloria  Offline
Member
Joined: May 2004
Posts: 364
Budapest, Hungary
Hello!

I'm having problems with using access or sql. Can anyone help me?

1., I want to put together two coloumns. In excel I'd do it with concatenate. In access? There are some built-in functions, but I dunno which one to use. (It is not a solution to do it in excel, while the base datas can change and I have to run this update query some times.

2., How to choose a row of numbers from a database if I don't know, how long the number is?
This case it is telephone numbers, which cal be 1 - 7-8 long. How to look it up?

Thank you in advance,

Gloria


The world is full of beauty if the heart is full of love

Tools for Electricians:

#132073 - 02/20/05 12:51 PM Re: SQL and Database help  
JCooper  Offline
Member
Joined: Dec 2002
Posts: 228
Kendall Park, NJ USA
Gloria, you can concatenate in SQL with the 'concat' command

eg 'Insert into table1.field3 concat(table1.field1+table1.field2)'

I think that would work for you, but the concat is the concatenate command for SQL.

As far as the query for the phone number how is it structured? Is each number in its own column and you need to select non-null values?

'select * from table1 where column<>'0''


#132074 - 02/21/05 02:34 AM Re: SQL and Database help  
Gloria  Offline
Member
Joined: May 2004
Posts: 364
Budapest, Hungary
Hello!

Thank you, I'll try.
The problem with the phone numbers is that I don't know, how long it is.
The best would be if I could enter 2-3-4-5, any numbers and it would recognize the location, I mean in the databases there are country and local numbers. For ex. 18007654321 and if I type 18007 it would recognize the 1800 which is in the list.


The world is full of beauty if the heart is full of love

#132075 - 02/21/05 02:40 AM Re: SQL and Database help  
Gloria  Offline
Member
Joined: May 2004
Posts: 364
Budapest, Hungary
Dear JCooper!

Sorry, It was not working in access. [Linked Image]
I thought I had to make an update query, cause the base data table can change.

Any advise?


The world is full of beauty if the heart is full of love

#132076 - 02/23/05 11:44 AM Re: SQL and Database help  
Gloria  Offline
Member
Joined: May 2004
Posts: 364
Budapest, Hungary
I visited the ms online forum for help and that is -I must say - a very good site. there are very skilled people helping.

I can suggest to use it.


The world is full of beauty if the heart is full of love


Member Spotlight
renosteinke
renosteinke
Blue Collar Country
Posts: 5,316
Joined: January 2005
Show All Member Profiles 
Featured:

2017 NEC and Related
2017 NEC
Now Available!

Shout Box
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.012s Queries: 14 (0.003s) Memory: 0.7678 MB (Peak: 0.9050 MB) Zlib enabled. Server Time: 2017-04-26 23:32:08 UTC